following is my code:
For i = 100 to 1
If cells(1,i) <> "GM" AND If cells(1,i) <> "tURNOVER" AND If cells(1,i) <> "cONTRIBUTION" AND............Then
Selection.EntireColumn.Delete
There are 15 criteria, how do I shorten my code, maybe using an array?
not sure.
Thanks
Bookmarks