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.