On Sat, 9 May 2009 22:29:15 +0200, "Niek Otten"
wrote:

Look at Application.Caller (.Address)

Both of those get an error in the immediate window when the UDF is
running.

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.

I'm just trying to determine which cell in which sheet called the UDF.
Rick's solution gave me what I needed.