View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Wally Steadman[_3_] Wally Steadman[_3_] is offline
external usenet poster
 
Posts: 6
Default Delete Entire Rows

I have the following data in a spreadsheet:

IAN 3025364 3127372008000
FONDA 3025390 3125601110000
FRED 3025390 3125601110000
FRED 3025398 3005703448000
IAN 3025801 3025805491000
IAN 3025801 5805492000000
IAN 3025801 6312140000000
IAN 3025801 5878415000000
IAN 3025801 5878415000000
FRED 5346161 3127382840000
FRED 5346161 3127382284000
IAN 5394701 3127372421000

Is there a way in code to have it delete the rows where
the first set of numbers starts with 302 so the final list
would look like:

FRED 5346161 3127382840000
FRED 5346161 3127382284000
IAN 5394701 3127372421000

It will be looping through worksheets in the workbook and
there are alot of sheets so would like a way to run a
macro to do it. Any help would be appreciated. And
thanks to all those that have been helping me learn
programming in Excel.

Wally Steadman