Application.Caller returns a range object:

Function Func1() As String
Debug.Print Application.Caller.Address
Func1 = "test"
End Function


--
Tim Zych
SF, CA

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