I have read about Application Caller at this link
https://docs.microsoft.com/en-us/office ... ion.caller
And as for such a code
Code: Select all
Dim v
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
But I wonder how can Application.Caller returns a Range
Can you give me an example of that.