Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Record line number in macro where error occurs
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Record line number in macro where error occurs
This post will be helpful.
http://www.fmsinc.com/free/NewTips/V...ineNumber.html If this post is helpful click Yes --------------- Jacob Skaria |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Record line number in macro where error occurs
Thanks for tha. So we have to number the rows of the macro, which is a shame
as makes it look scrappy but then if that is it so be it. -- with kind regards Spike "Jacob Skaria" wrote: This post will be helpful. http://www.fmsinc.com/free/NewTips/V...ineNumber.html If this post is helpful click Yes --------------- Jacob Skaria |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Record line number in macro where error occurs
Spike,
For development work, in the VBE: Tools / Options "General" tab, check "Break on all errors" HTH, Bernie MS Excel MVP "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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 Error message when trying to record Macro | Excel Worksheet Functions | |||
how to copy line above when XXX occurs and move on? | Excel Programming | |||
Macro to enter record number in column A | Excel Programming | |||
Macro to Count how many times a number occurs on a day | Excel Programming | |||
how to count/sum by function/macro to get the number of record to do copy/paste in macro | Excel Programming |