I'm not sure what you are asking for. In a user defined function
in VBA, Application.Caller will return a Range reference to the
cell which called the function.
In a formula, ADDRESS(ROW(),COLUMN()) will return the address of
the cell containing the function.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
message
news:
[email protected]...