| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Delete Rows in A column not Containing multiple text criteria
I have been searching the net with no luck for finding VBA coding that will delete rows where the text in column A does not contain certain text.
I have a spreadsheet which has a header row at row 4 and the data starts from row 5. I need all rows in column A not containing the following text to be deleted: MGTADM PRJSTR PRJCON PRJCLS SUPSRV I found VB for containing text but not for not containing text. Can anyone help as I'm starting to get a little confused with all the codes I've found! Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Delete rows based on multiple criteria | Excel Discussion (Misc queries) | |||
| Code help, delete rows based on column criteria | Excel Discussion (Misc queries) | |||
| delete rows with multiple criteria | Excel Programming | |||
| Deleting rows, multiple column criteria | Excel Programming | |||
| Delete Rows based on criteria in Column A (not working) | Excel Programming | |||
Linear Mode
