Locating errors in macro code for dummies (like me)

Lt. Krul · May 16th, 2002, 09:37 AM

Is there a way to tell the macro to show me where the code stops when the error occurs - such as a marker or curser that is placed in the position in the code at the point the macro errors out? That would be a great help.

I remember from my old MS Basic programming days (early '80s) that when the program errored, the error read "subscript out of range error in line 30". then you know exactly, "Oh, it's that array that caused the problem!" Oh, for the good 'ol days.

Von Pookie · May 16th, 2002, 09:41 AM

If you "step into" the macro by using F8, when it hits an error it will highlight the offending line in yellow (at least for me, it does).

Jack in the UK · May 16th, 2002, 10:05 AM

Hi Kristy - first you dead on (correct)

debug / compile will allow a check also, and there are VBA utility’s out there, mix results from what im told

I would always say post he code and some guru lurk on this board, they will soon have you in check

post the code we will look it over

Jack in the UK · May 16th, 2002, 10:08 AM

sorry did not see same question

see http://www.mrexcel.com/board/viewtop...345&forum=2&12

Mark O'Brien · May 16th, 2002, 10:26 AM

Jack

I was reading this thread and I wondered where all the other posts went.

Lt. Krul · May 16th, 2002, 10:56 AM

Kristy -

Yes, you were Dead on!!!
The stepping F8 indicated that the error occurs when I try to execute the following command:

For shtcnt = sheets.Count To 1 Step -1 ' cycles through worksheets from back to front

sheets(shtcnt).Activate 'activates current worksheet in the workbook. THIS IS THE LINE THAT ERRORS OUT!!!

If sheets(shtcnt).Visible = False Then GoTo 25

If Sheets(shtcnt) is an array, then do I need to dimension it, and if so, how? My watch window tells me that the value of shtcnt is never below 1.

Mark O'Brien · May 16th, 2002, 11:06 AM

Quote:

On 2002-05-16 09:56, Lt. Krul wrote:
Kristy -

Yes, you were Dead on!!!
The stepping F8 indicated that the error occurs when I try to execute the following command:

For shtcnt = sheets.Count To 1 Step -1 ' cycles through worksheets from back to front

sheets(shtcnt).Activate 'activates current worksheet in the workbook. THIS IS THE LINE THAT ERRORS OUT!!!

If sheets(shtcnt).Visible = False Then GoTo 25

If Sheets(shtcnt) is an array, then do I need to dimension it, and if so, how? My watch window tells me that the value of shtcnt is never below 1.

It's not an array problem. If the sheet is not visible, you can't activate it. You need to test if the sheet is visible first. You've got your code round the wrong way here.

May 16th, 2002, 09:41 AM	#2
Von Pookie MrExcel MVP, Administrator Join Date: Feb 2002 Location: The act or process of locating. Posts: 13,679	If you "step into" the macro by using F8, when it hits an error it will highlight the offending line in yellow (at least for me, it does). __________________ Kristy How to post (Video) Show your sheet on the board (HTML Maker FAQ)

May 16th, 2002, 10:05 AM	#3
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,064	Hi Kristy - first you dead on (correct) debug / compile will allow a check also, and there are VBA utility’s out there, mix results from what im told I would always say post he code and some guru lurk on this board, they will soon have you in check post the code we will look it over __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

May 16th, 2002, 10:08 AM	#4
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,064	sorry did not see same question see http://www.mrexcel.com/board/viewtop...345&forum=2&12 __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

May 16th, 2002, 10:26 AM	#5
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	Jack I was reading this thread and I wondered where all the other posts went. __________________ Mark O'Brien Columbus Ohio Celtic Supporters Club

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 16th, 2002, 09:37 AM	#1
Lt. Krul New Member Join Date: May 2002 Posts: 31	Is there a way to tell the macro to show me where the code stops when the error occurs - such as a marker or curser that is placed in the position in the code at the point the macro errors out? That would be a great help. I remember from my old MS Basic programming days (early '80s) that when the program errored, the error read "subscript out of range error in line 30". then you know exactly, "Oh, it's that array that caused the problem!" Oh, for the good 'ol days.

May 16th, 2002, 10:56 AM	#6
Lt. Krul New Member Join Date: May 2002 Posts: 31	Kristy - Yes, you were Dead on!!! The stepping F8 indicated that the error occurs when I try to execute the following command: For shtcnt = sheets.Count To 1 Step -1 ' cycles through worksheets from back to front sheets(shtcnt).Activate 'activates current worksheet in the workbook. THIS IS THE LINE THAT ERRORS OUT!!! If sheets(shtcnt).Visible = False Then GoTo 25 If Sheets(shtcnt) is an array, then do I need to dimension it, and if so, how? My watch window tells me that the value of shtcnt is never below 1.