How to get reference to a range as string?

J

jtan

I can get a reference to a cell as string with function CELL("address",
A1), which will return the string $A$1. How do I get a reference to a
range, for instance, A1:A5?


Thanks.
 
D

David McRitchie

How will you be using it.

I expect you would have to use a user defined function.

MsgBox Range("mrange").Address
 
Top