close

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

ThanksAndrew

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 Studentquot;AJPendragonquot; wrote:

gt; I want cell A1 to return the cell position I am currently in?
gt;
gt; Thanks
gt;
gt;
gt; Andrew

全站熱搜
創作者介紹
創作者 software 的頭像
software

software

software 發表在 痞客邦 留言(0) 人氣()