delete columns with excel vba

Hi all,

I have used some code to delete columns. If I do it with the mouse, and then select the right mouse button (having the mouse in the column letter), it will delete all (even when there is columns with a color fill and formating).

How can this be done using code?

this will not work:

Sub Delete_EntireColumn()
Columns(1).EntireColumn.Delete
End Sub

Greetings.

Re: delete columns with excel vba

Hi Sktneer,

Thanks a lot. I will try it out tomorrow.

Greetings.