Source of call to UDF
 

Hi.

How to find out which cell called udf function?
I did it once, but I don't remember hwo.

Thanks

Source of call to UDF
 

witek wrote:
Hi.

How to find out which cell called udf function?
I did it once, but I don't remember hwo.

Thanks

Ok. I found it.
Application.Caller.Address

Source of call to UDF
 

Application.Caller.Address

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"witek" wrote in message ...
| Hi.
|
| How to find out which cell called udf function?
| I did it once, but I don't remember hwo.
|
| Thanks