View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
nospam nospam is offline
external usenet poster
 
Posts: 6
Default delete rows using macro

This doesn't seem to work. I inserted into the beginning of my macro
code, but keep getting errors - invalid inside procedure at Option
Explicit, etc. Also, do I need to indicated Sheet1 in my code somewhere?
That is where I need to remove the unneeded rows?

Thanks for all your help.

Martin Fishlock wrote:
Karl,

Change
szWords = Array("word1", "word2", "word3")
to
szWords = Array("General Boarding", "Wait List")
and it will delete the all rows on the active sheet that contain one or all
of the headings in quotes above.

You can then do the other things.