| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete Rows based on cell value
Hi. I'm trying to create a macro that will delete rows where the
value in column E does not equal "ABC". I always have a different number of rows of data so I can't use a fixed range. Also, rows 1-5 are my header rows so I don't want to touch them--so the macro should start looking at column E in row 6 and continue until it hits a row where column E is blank. Thanks 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 | |||
| Delete Rows based on cell values. | Excel Programming | |||
| Delete duplicate rows based on part of cell. | Excel Programming | |||
| Delete rows based on Cell name | Excel Programming | |||
| Hide/Delete entire rows based in the content of one cell | Excel Discussion (Misc queries) | |||
Threaded Mode
