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 = -1 then return the current line. If Depth = 0 then return the calling subroutine's current line, etc.. If Depth is greater than or equal to the call stack depth then a null string is returned. If this value is omitted then the depth is 0.

Example:

Sub Main
  A
End Sub

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