Formula to return cell position
 

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

Thanks


Andrew

Formula to return cell position
 

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)
--
Gary''s Student


"AJPendragon" wrote:

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

Thanks


Andrew