referring cell in macro function

Z

zxcv

If a create a macro intended to be used as a function in a worksheet
is there a property of the referring cell?

I want to know what cell the formula is in.
 
J

JLGWhiz

Dim callCell As String
callCell = Application.Caller.Address

Returns the cell address of the cell where the UDF is used.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top