Err.LineNumber

[mangesh_yadav]

Hi,

is there nothing in VBA which gives the line number of the line wher
the error occurs. It becomes quite difficult to find a problem on th
users machine when a bug comes up

 

[NickHK]

mangesh,
There is the Err.Erl, but you have to number all you lines for this to work.
MZ-Tools have an add-in that can do this.
(Applies to VB, so I am assuming it applies to VBA also.)

NickHK