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
|