| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete Rows for given conditions.
I'm looking for some coding help. I have a large worksheet of data that
varies in length (well over 4k rows) and I'm looking to delete rows based on a "code" entered in col E. The "code" in col E is text based and varies in length. I have a list of 85 or so codes that I want to delete from the data sample without having to perform this manually. I've found code to delete rows based on a cell value, but cannot figure out how to make it loop through all of the codes I have to remove. Is this even possible? Any help would be greatly appreciated. Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel - 2003 - Delete data if conditions met | Excel Discussion (Misc queries) | |||
| Delete variable # of rows depending on conditions | Excel Programming | |||
| how to write to macro to only delete rows under certain conditions | Excel Programming | |||
| Delete the contents of a cell under multiple conditions | Excel Programming | |||
| Delete every 3rd row, then delete rows 2-7, move info f/every 2nd row up one to the end and delete the row below | Excel Programming | |||
Threaded Mode
