referring cell in macro function

[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.

 

[JLGWhiz]

Dim callCell As String
callCell = Application.Caller.Address

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

 

[zxcv]

Dim callCell As String
callCell = Application.Caller.Address

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

Thanks.