View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default 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