View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Rick Rothstein Rick Rothstein is offline
external usenet poster
 
Posts: 5,934
Default Record line number in macro where error occurs

Get MZTools... it's free and it's great! One of the many, many things it
does is allow you to add and remove line numbers at will.

http://www.mztools.com/v3/mztools3.aspx

--
Rick (MVP - Excel)


"Spike" wrote in message
...
When trapping errors, is it possible to record the line in the macro where
the error occurred so in the Error Trapping routine one can note this line
to
assist in finding the error.

I copy error details to an Error Log so it would be handy to have the line
in the macro where the error trapping routine was triggered.
--
with kind regards

Spike