Excel 2000 Code works except in debug mode

B

Bob Smedley

When trying to debug some of my code in step mode for an Excel 2000
spreadsheet I get to this particular
line and it just stops.

ActiveWorkbook.Worksheets("StatusData").Select
On Error Resume NextIf (Err.Number <> 0) Or (strTest = "FALSE") Then

The error object is not filled, nothing. It acts as is the statement was
"End".

strTest is Dim'd as a string.
The range "Vision" that I am looking for does not exist (that's why I'm
doing in line error checking).

The code works fine when the subroutine is run normally.

Any ideas?

thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro Works but not in Debug Step mode 3
Macro just stops in Step Mode 0
Working outlook via vba code with xlsx - error 0
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
Macro works, but only if you 'step' through it - Word 2000 2
Code Works Fine in Excel 2007, Excel 2000 generates Runtime Error 438 0
Addin Auto_Open code executes only in debug mode 2
Code only works in Debug mode. Why? 6

Top