How do I get the address of the cell that is being calculated right now?
 

I'd like to be able to tell the user which cell has an error (such as an
invalid parameter) when my function might be called from many cells (such as
after a PASTE).

How can I identify which cell is being calculated (get the address) when my
function is called, from within that function?

Thanks!

---Wayne

How do I get the address of the cell that is being calculated right now?
 

set rng = Application.Caller
msgbox rng.Address

--
Regards,
Tom Ogilvy


"Wayne Erfling" wrote in message
...
I'd like to be able to tell the user which cell has an error (such as an
invalid parameter) when my function might be called from many cells (such
as
after a PASTE).

How can I identify which cell is being calculated (get the address) when
my
function is called, from within that function?

Thanks!

---Wayne