Cell Name

[Andy Chan]

Dear all,

How can I retrieve the cell reference? I want to write a function
MyFunction which gives the string "B3" when MyFunction() is input in B3 of a
worksheet. Thanks in advance!

Best Regards,
Andy

 

[Bob Phillips]

=CELL("address")

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[Dave Peterson]

function myfunction() as string
myfunction = Application.caller.address(0,0)
end function