How to get reference to a range as string?

  • Thread starter Thread starter jtan
  • Start date Start date
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.
 
How will you be using it.

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

MsgBox Range("mrange").Address
 
Back
Top