Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Works but not in Debug Step mode
When trying to debug some of my code in step mode I get to this particular
line and it just stops. ActiveWorkbook.Worksheets("StatusData").Select On Error Resume Next strTest = Range("Vision").Text <<<< stops on this line If (Err.Number < 0) Or (strTest = "FALSE") Then The error object is not filled, nothing. It acts as is the statement was "End". I've also tried it with "strTest = Worksheets("StatusData").Range("Vision").Text" but does the same thing. 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). Any ideas why it would just stop without any notification of why in step mode but work properly when run normally? thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2000 Code works except in debug mode | Excel Programming | |||
How show value of variable by mouse-over in debug single step mode | Excel Programming | |||
How show value of variable in single step debug mode? | Excel Programming | |||
My VBA code works in the step though mode but not at full speed | Excel Programming | |||
Debug Step vs Run Mode | Excel Programming |