CallersLine Function

Syntax:
CallersLine[(Depth)]
Group: Miscellaneous
Description:
Return the caller's line as a text string.

The text format is: "[macroname|subname#linenum] linetext".
Parameter Description

Depth This integer value indicates how deep into the stack to get the caller's line. If Depth = 0 then return the current line. If Depth = 1 then return the calling subroutine's current line, etc.. If Depth is greater than the call stack then a null string is returned. If this value is omitted then the depth is 1.
Example:

Sub Main
A
End Sub
Sub A
Debug.Print CallersLine ' "[(untitled 1)|Main# 2] A"
End Sub