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

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