Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Detect for empty excel sheet
I need to detect a empty excel sheet by VBA.
I know that CountA(Activesheet) = 0 and Activesheet.Shapes.Count = 0 is Useful. But I found that it is not sufficient. For example, if I just change the background color and the border of Cell A1. The code will return true even the Activesheet is not empty at all. I also tried about the code for Activesheet.UsedRange. But I found that if the sheet is empty, it will always return A1:A1. But again, it is not sufficient. At least it cannot pass the above test case. Could any one tell me how to test a excel sheet is empty or not in all cases? I think it is possible, because some Excel Add-Ins can do that. Thank you very much. Stephen Lai |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to detect if sheet is hidden? | Excel Worksheet Functions | |||
How do I detect the first empty cell is column A | Excel Programming | |||
How do I detect the first empty cell is column A | Excel Programming | |||
detect empty cell | Excel Programming | |||
Detect whether a row is completely empty | Excel Programming |