ExcelBanter - referring cell in macro function

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - referring cell in macro function (https://www.excelbanter.com/excel-programming/442168-referring-cell-macro-function.html)

zxcv[_2_]

referring cell in macro function

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[_2_]

referring cell in macro function

Dim callCell As String
callCell = Application.Caller.Address

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

"zxcv" wrote in message
...
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.

zxcv[_2_]

referring cell in macro function

On Apr 29, 3:50*pm, "JLGWhiz" wrote:
Dim callCell As String
callCell = Application.Caller.Address

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

"zxcv" wrote in message

...

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.

Thanks.

All times are GMT +1. The time now is 12:19 PM.