ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Excel 2000 Code works except in debug mode (https://www.excelbanter.com/excel-programming/351258-excel-2000-code-works-except-debug-mode.html)

Bob Smedley

Excel 2000 Code works except in debug mode
 
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





All times are GMT +1. The time now is 02:34 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com