Cell Name

A

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
 
B

Bob Phillips

=CELL("address")

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
D

Dave Peterson

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