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