| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete rows if particular cell empty
I need to include an instruction in a macro to delete rows, based on one cell
being empty. If cell c10 (range name = "deliver_line1") is empty, then I want to delete rows 10 to 15 (range name = "deliver_rows). I have used Range("Item_Nos").SpecialCells(xlCellTypeBlanks).E ntireRow.Delete elsewhere, but this must relate to a cell which is not the first in the row. Grateful for any help, thanks. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Delete rows if particular cell empty
If IsEmpty(Range("deliver_line1")) Then
Sheets(1).Rows("10:15").EntireRow.Delete End If "Code Numpty" wrote: I need to include an instruction in a macro to delete rows, based on one cell being empty. If cell c10 (range name = "deliver_line1") is empty, then I want to delete rows 10 to 15 (range name = "deliver_rows). I have used Range("Item_Nos").SpecialCells(xlCellTypeBlanks).E ntireRow.Delete elsewhere, but this must relate to a cell which is not the first in the row. Grateful for any help, thanks. |
| Reply |
| 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 | |||
| Cut filtered rows, paste into next empty row of new sheet, and delete cut rows | Excel Worksheet Functions | |||
| Delete Rows with Empty Cells with empty column 1 | Excel Programming | |||
| Delete empty rows with cell type 2 | Excel Discussion (Misc queries) | |||
| Delete rows foward if cell is empty | Excel Programming | |||
Hybrid Mode
