| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Return Range Address from Active Range
I know that I can return the address from the Active Cell by looking at the
Address property of the object: ActiveCell.Address How do I do this if the object is a range that is hightlighted? ActiveRange.Address does not seem to work. There does not seem to be an object called ActiveRange Thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Return Range Address from Active Range
Hi Monkey.
Try: Selection.Address --- Regards, Norman "ExcelMonkey" wrote in message ... I know that I can return the address from the Active Cell by looking at the Address property of the object: ActiveCell.Address How do I do this if the object is a range that is hightlighted? ActiveRange.Address does not seem to work. There does not seem to be an object called ActiveRange Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can change range to select active rows instead of :=Range("S10 | Excel Discussion (Misc queries) | |||
| return cell address of longest text string in a range | Excel Discussion (Misc queries) | |||
| How to return the address of the range of plotted data on an XY scatter chart? | Charts and Charting in Excel | |||
| Need VBA macro to return active cell address (R1C1) | Excel Programming | |||
| Formula to return ADDRESS of cell in range that meets criteria | Excel Worksheet Functions | |||
Hybrid Mode
