[ACCEPTED]-How to get address of cell which calls a VBA Functions in a Excel sheet-excel
Accepted answer
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
See: http://www.cpearson.com/excel/WritingFunctionsInVBA.aspx
To pass the cell:
=SomeFunction(A1)
Where 1 the code has:
SomeFunction(r)
Source:
stackoverflow.com
More Related questions
Cookie Warning
We use cookies to improve the performance of the site. By staying on our site, you agree to the terms of use of cookies.