How to add alternate column in worksheet

[aadityapatel]

I have column in B,C,D,E,F position with some data in my workbook how can i add new column in alternate position using vba
like B new column C new column D new column E new column D new column using vba

please help

[GTO]

...how can i add new column in alternate position using vba like B new column C new column D new column E new column D new column using vba

What?

Could you show us in a workbook attachment, what it is you are trying to accomplish?

Mark

[Aflatoon]

Perhaps like so:


Range("C1,D1,E1,F1,G1").EntireColumn.Insert