| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
.SpecialCells(xlCellTypeBlanks).EntireRow.Delete
Is there a test (and what is it?) that could be used to avoid using on
error resume next before a line like this? ..SpecialCells(xlCellTypeBlanks).count returns an error if there are no blanks in the referred-to range. Thanks! Cliff Edwards |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Work around to SpecialCells(xlCellTypeBlanks)... | Excel Discussion (Misc queries) | |||
| Check SpecialCells(xlCellTypeBlanks) for 0 blanks | Excel Programming | |||
| Using SpecialCells().EntireRow.Delete on large worksheet - Very slow! | Excel Programming | |||
| Help to hide rows, SpecialCells(xlCellTypeBlanks) doesn't work... | Excel Programming | |||
| specialcells(xlcelltypeblanks) | Excel Programming | |||
Threaded Mode
