Identify User Selected Range

  • Thread starter Thread starter RonF
  • Start date Start date
Thanks, I've looked for this all weekend.

Ron
-----Original Message-----


Yes, it its referred as "Selection".

Ex: Selection.Address Will return the address of the range of cells
selected by the user.

Regards,
--
Beto
Reply: Erase between the dot (inclusive) and the @.
Responder: Borra la frase obvia y el punto previo.

.
Click to expand...
 
RonF said:
Is there a way to identify a range of cells highlighted by
the user?
Click to expand...

Yes, it its referred as "Selection".

Ex: Selection.Address Will return the address of the range of cells
selected by the user.

Regards,
 
Hi Ron,
Most of my macros do involve a user selected selection range.
I think the following web page might be particularly helpful to you.

Proper, and other Text changes -- Use of SpecialCells
http://www.mvps.org/dmcritchie/excel/proper.htm

If for no other reason than to show you what to look for in your
own code and in code presented by others so that you can
run more efficiently.

after reading the above web page, you might also look at
Rearranging Data in Columns
http://www.mvps.org/dmcritchie/excel/join.htm

Of course if you have a more specific question that can be
used generically there is likely to be coding which you might
find by searching the newsgroup archives.
Excel Newsgroups & Searching Newsgroups
Search Newsgroups using Google "Usenet Advanced Search",
look at the MS Knowledge Database, other tips.
http://www.mvps.org/dmcritchie/excel/xlnews.htm
 
Back
Top