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
|