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

"mangesh_yadav" wrote in
message ...

Hi,

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


--
mangesh_yadav


------------------------------------------------------------------------
mangesh_yadav's Profile:
http://www.excelforum.com/member.php...o&userid=10470
View this thread: http://www.excelforum.com/showthread...hreadid=276918