|
-
Jan 5th, 2000, 04:08 AM
#1
Thread Starter
Junior Member
I am reading an excel sheet from my Visual Basic application. I want the program to perform until it comes upon an empty cell. The problem is when I use this code
Do While Not objExcel.Range(cbochan1col & rowcnt).Value = Empty
Visual Basic is reading 0's as empty.
Suggestions on how to bypass this so that the program doesn't exit when coming upon a zero?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|