this also works with .address
myRange = .range("a1")
? myRange.address
or if you have named a range called "Cell5"
ThisRange = .Range("Cell5)
? ThisRange.Address