View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Nate[_6_] Nate[_6_] is offline
external usenet poster
 
Posts: 7
Default Delete Columns not containing certain values

Hello,

I'm having trouble writing a VBA macro that deletes columns. I have a
spreadsheet with a bunch of columns containing various data.

What I want to do is delete every column that doesn't have either
"NO.", "QTY." or "DESCRIPTION" in it. I have about 1000 sheets that I
need to clean up and a macro would make this much easier on me.

I already have a macro which deletes the rows I don't need, now I'd
like to add code to delete the columns.

Any suggestions?

Thanks in advance,

-Nate