[ACCEPTED]-How to get address of cell which calls a VBA Functions in a Excel sheet-excel
You can use Application.Caller, but you 3 would probably be best to pass the cell 2 to the function.
With Application.Caller CallerRows = .Rows.Count CallerCols = .Columns.Count CallerAddr = .Address End With
To pass the cell:
Where 1 the code has:
More Related questions