Delete colomn depending on a cell value

[turkanet]

Dear friends,
i need your help for below;

if E12 is "AAA" then, delete colomn E

thank you

[myou]

Hello turkanet,

Do you really want to DELETE Columns E, or only clear its data?

[turkanet]

Dear myou, i need to delete this colomn

[myou]

Hello turkanet,

There are many ways to do it. I don't know if you require the following Code, which goes into the Worksheet Code;

Please Login or Register  to view this content.

[myou]

Hi turkanet,

Another way is to add a Module to your Workbook, with a Button on the appropriate sheet, which you click to delete column E.

Please Login or Register  to view this content.

Try the attached sample workbook.

[turkanet]

Dear myou, thank you very much really.