Identify User Selected Range
 

Is there a way to identify a range of cells highlighted by
the user?

Thanks

Identify User Selected Range
 

Thanks, I've looked for this all weekend.

Ron
-----Original Message-----
RonF wrote:

Is there a way to identify a range of cells highlighted
by
the user?


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.

.

Identify User Selected Range
 

RonF wrote:

Is there a way to identify a range of cells highlighted by
the user?


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.

Identify User Selected Range
 

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
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"ronf" wrote in message ...
Thanks, I've looked for this all weekend.

Ron
-----Original Message-----
RonF wrote:

Is there a way to identify a range of cells highlighted
by
the user?


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.

.