Macro to delete column from worksheet in a workbook

[Chetan Chauhan]

Hi,

I have a workbook with 9 sheets. There are data in worksheet with different column heading. I have to delete column with heading Total1, Total2 and Total3. Its not necessary that every sheet is having these column. If it have one column then it will be Total1, if 2 then Total1 & Total2 likewise. Some times it may not have any such column.

Is there any way I can have a macro which search and delete these column.

Thanks in advance

[ravishankar]

Hi
try the following macro codes. I assume titles are on row 1 (else change the red text).Test it on a copy of your workbook before you use it.

Please Login or Register  to view this content.

Ravi