| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
delete rows with empty cells throughout the data
gr,
Range("A1:I400").SpecialCells(xlCellTypeBlanks).En tireRow.Delete HTH, Bernie MS Excel MVP "rutski" wrote in message ... How would i delete the rows of data if any of the cells are empty for say a range a1 to i400? thanks, gr |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to Delete empty rows in excel in b/w rows with values | Excel Worksheet Functions | |||
| delete rows with empty cells | Excel Discussion (Misc queries) | |||
| Cut filtered rows, paste into next empty row of new sheet, and delete cut rows | Excel Worksheet Functions | |||
| How can I globally delete empty cells or rows in different places | Excel Discussion (Misc queries) | |||
| Delete rows with empty cells in columns B&C | Excel Discussion (Misc queries) | |||
Threaded Mode
