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.




salah wrote:

the function below should work..

=+CELL("address",A1)
_______________________
salah

"LarryL" wrote:

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

Thank You

--

Dave Peterson