Formula to return cell position

A

AJPendragon

I want cell A1 to return the cell position I am currently in?

Thanks


Andrew
 
G

Gary''s Student

Enter this tiny UDF:


Function whereami() As String
whereami = Selection.Address
End Function

In A1 enter =whereami()
Click on any cell
Touch CNTRL-ALT-F9 and A1 will tell you where are.


(kind of works like GPS)
 
Top