Get Address of Active Cell

L

LarryL

Is there a function to access the address of the Active Cell without having
to revert to Visual Basic?

Thank You
 
D

Dave Peterson

Won't that always return $A$1?

The original poster could use:
=CELL("address")&text(rand(),";;;")
(that + isn't necessary)

But it could be one calculation behind.
 
Top