| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Delete row based on contents of cell
The following code does a great job of finding whole blank rows and deleting
them: Range("B1", Range("B65536").End(xlUp)).SpecialCells _ (xlCellTypeBlanks).EntireRow.Delete However, could someone please tell me how to modify this for two other purposes: 1) Delete the whole row if any cell in column A: is has the contents of "SSN" 2) Delete the whole row if any cell in column C: is blank (null?) Thank you in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I conditionally delete rows based on cell contents? | Excel Worksheet Functions | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
| Sum numbers based on the contents of another cell | Excel Worksheet Functions | |||
| Lookup cell contents in on sheet based on a formula in second sheet | Excel Worksheet Functions | |||
| Returning a Value to a Cell Based on a Range of Uncertain Size | Excel Worksheet Functions | |||
Threaded Mode
