On Sat, 9 May 2009 16:01:36 -0400, "JLGWhiz"
wrote:

Here is something out of the VBA help files.

This example displays information about how Visual Basic was called.

Select Case TypeName(Application.Caller)
Case "Range"
v = Application.Caller.Address
Case "String"
v = Application.Caller
Case "Error"
v = "Error"
Case Else
v = "unknown"
End Select
MsgBox "caller = " & v


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

Thanks. I'll have to study that one.