Look at Application.Caller (.Address)
Remember that the active sheet/book doesn't have to be the one that a UDF
was called from
It all depends on what you're trying to achieve. Maybe you should post that.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Prof Wonmug" wrote in message
...
What property do I need to qeury to obtain the name of the workbook,
sheet, and cell where a UDF or macro was called?