Hi. I made a thread before but I'm not sure if it's clear what I want, as it's a bit difficult without showing you my data. So I thought this would be an easier way to ask, that might still help me achieve what I need.
So let's say for example that I have the following code in my macro, to make it add a couple of empty columns next to column F:
Now say that I also want to do the same thing to the rest of my columns, for example to add a couple of empty columns next to column H.
To save me from needing to past the above code and manually change the column letter over and over, is there a code that automatically says "do this thing for every second column"?
So let's say for example that I have the following code in my macro, to make it add a couple of empty columns next to column F:
VBA Code:
Columns("F:F").Insert Shift:=xlToRight, CopyOrigin:=xlFormatFromLeftOrAbove
Now say that I also want to do the same thing to the rest of my columns, for example to add a couple of empty columns next to column H.
To save me from needing to past the above code and manually change the column letter over and over, is there a code that automatically says "do this thing for every second column"?