View Single Post
  #2   Report Post  
Chip Pearson
 
Posts: n/a
Default

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



"???????????" wrote in
message
...
Please confirm the correct answer to the below question

cell reference in a formula is called?