Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() I need to delete 2 rows if a cell is blank. At the moment I am using the following to delete the row which the blank cell is situated in. Range("C12:C81").SpecialCells(xlBlanks).EntireRow. Delete This works fine. However, I also need to delete a second row relative to the first row. i.e. Cell C12 is blank Row 12 is deleted Row 112 is deleted When deleting the first row (row 12) the second row to be deleted is now row 111. This process is repeated through the range C12:C81. Obviously as more rows are deleted, the relative row changes. HELP - Any suggestions will be much appreciated. Thanks in advance, Darren. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Need Help Deleting Blank Rows | Excel Worksheet Functions | |||
Deleting blank rows | Excel Worksheet Functions | |||
Deleting Blank Rows | New Users to Excel | |||
Deleting blank rows | Excel Programming | |||
Deleting blank rows | Excel Programming |