Solved: Delete just 2 column

[parscon]

I need a VBA code to delete only 2 column of my sheet .

Column A-B and just delete column not row .

Thank you .

[Bob Phillips]

Have you not tried


Columns("A:B").Delete

[parscon]

Thank you so much it is a big help me , ibut i wrote wrong , i need to clean the data on these 2 column .

Thank you for your fast reply .

[Bob Phillips]

With ActiveSheet

Intersect(.UsedRange, .Columns("A:B")).ClearContents
End With

[parscon]

Thank you so much .