Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 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". 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VBA Code works in Excel 2003 but won't work in Excel 2000 | Excel Programming | |||
VBA Code works in Excel 2003 but won't work in Excel 2000 | Excel Programming | |||
My VBA code works in the step though mode but not at full speed | Excel Programming | |||
My VBA code works in the step though mode but not at full speed | Excel Programming | |||
Code works with Excel 2000 but not with Excel 2002 | Excel Programming |