| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting rows with a two criteria
I need to edit this code to delete rows if cells in column B are empty AND if
the corresponding cell in Column A is MC, Disc or Visa, is that possible? Sub delRows() Range("B:B").SpecialCells(xlCellTypeBlanks).Entire Row.Delete End Sub |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Deleting several rows with given criteria | Excel Discussion (Misc queries) | |||
| Deleting rows by specified criteria for duplicates | Excel Discussion (Misc queries) | |||
| Deleting Rows w/ Specific Criteria | Excel Discussion (Misc queries) | |||
| Help - Deleting Rows on Text Criteria | Excel Programming | |||
| Deleting rows based on criteria | Excel Programming | |||
Threaded Mode
