| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
delete just empty rows
how can I delete just empty rows of a sheet
with the following code I can just delete empty cells and after that the rows are not the same as before (have different values). Sub emptyCellsDelete() sheet1.Cells.Range("A6:M155").SpecialCells _ (xlCellTypeBlanks).Delete shift:=xlUp End Sub |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hpw do I delete multiple empty rows found between filled rows? | Excel Worksheet Functions | |||
| Delete Empty Rows | Excel Discussion (Misc queries) | |||
| How to Delete empty rows in excel in b/w rows with values | Excel Worksheet Functions | |||
| Cut filtered rows, paste into next empty row of new sheet, and delete cut rows | Excel Worksheet Functions | |||
| Delete Empty Rows | Excel Programming | |||
Threaded Mode
