find activecell in Excel - not via VBA

[Spock's Brain]

Is there a function in Excel that will return the active cell? Without going thru VBA?
I would like the value in B1 to change based on the current active cell position.

I seem to remember such a function in Lotus but that was some time ago & I could be wrong.

 

[Russell Hauf]

Don't think so.

 

[Mark O'Brien]

Out of interest, what would you apply such a function to, if such a function existed?