View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
DesertCyclist DesertCyclist is offline
external usenet poster
 
Posts: 13
Default Address of calling cell?

Thank you all. This did the trick!

"Bob Phillips" wrote:

Application.Caller.Address

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"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.