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
|