View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
fpd833 fpd833 is offline
external usenet poster
 
Posts: 23
Default 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!