Thread: Address of calling cell?
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
  
Posts: 7,247
Default Address of calling cell?
In a UDF, Application.Caller returns a Range object referencing the cell
from which it was called.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)

"DesertCyclist" wrote in message
...
Is there a way for a UDF to know the address of the cell that called it?
That
cell may not be the active cell!

Thank you.

Reply With QuoteReply With Quote