| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need to test for a blank worksheet.
Hi Everyone,
What can I use to test if a sheet is completely blank? UsedRange.Rows.Count doesn't work because it yields an answer of "1" even for a newly created sheet. Any help would be appreciated. Regards Greg |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Need to test for a blank worksheet.
Never mind. I found it: Application.CountA(ActiveSheet.Cells)
<The things you can find in this newsgroup if you just look! :-) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| A logical test in the If function for blank, i.e., If blank? | Excel Worksheet Functions | |||
| Range or test for blank? | Excel Programming | |||
| Macro code to test for blank row and insert blank row if false | Excel Programming | |||
| Test for blank lines | Excel Programming | |||
| Excel VBA Test For Blank Cell | Excel Programming | |||
Hybrid Mode
