Delete columns in tabs which meet a certain criteria

Hi all,

Can someone help with the below problem please.

I have a workbook with lots of tabs and I want to delete certain columns from each tab (after the data has been added).

I don't want to delete from all the tabs - only from the ones where row 1 has the word 'Delete' in a cell.

i.e. if A1 has 'Delete' then delete then column A in tab 1 but if cell C1 has the word 'Delete' in tab 2 then delete column C in tab 2 etc.

Hope than makes sense.

Thanks

Hello Ummy,

Try the following code:-

Please Login or Register  to view this content.

It does assume that the word "Delete" is to be found only in Row1 of any worksheet.

I hope that this helps.

Cheerio,
vcoolio.