Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Identify User Selected Range
Is there a way to identify a range of cells highlighted by
the user? Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
dynamic chart on user selected data range in Excel 2007 | Charts and Charting in Excel | |||
Identify Range Selected By User | Excel Programming | |||
Identify if another user has spreadsheet open - in VBA | Excel Programming | |||
Determining end of user-selected range | Excel Programming | |||
How to find out what the user selected? | Excel Programming |