Hi,

I need help with writing the code for the following. All help is appreciated.

I have a spreadsheet with probably 50 columns. There are about 10 columns that I need to keep while deleting the rest, based on the column header (first row).

So, for example, there are ten columns with the first cells as – keep1, keep2,… etc
And 40 columns with first cells as - delete1, delete2,… etc

So, excel needs to loop through the first row of the spreadsheet deleting the columns whose names are not keep1, keep2 etc.

Many thanks.

Amit