Macro to insert n columns every nth column

[kreese]

I need a macro written that I will help me add 6 columns every other column beginning at column F. I have tried to edit the other macros in this forum, but I am having trouble understanding them enough to fit my needs.

Any help is appreciated.

[tehneXus]

for example:

Please Login or Register  to view this content.

[AB33]

Please Login or Register  to view this content.

[kreese]

Unfortunately this added 1 column every 6 columns rather than 6 columns every other column. Wasn't sure what changes to make to fix it. Thanks for the reply.

[HaHoBe]

Hi, kreese,

start from the right and work backwards towards F:

Please Login or Register  to view this content.

Ciao,
Holger

[kreese]

for example:

Please Login or Register  to view this content.

Unfortunately this added 1 column every 6 columns rather than 6 columns every other column. Wasn't sure what changes to make to fix it. Thanks for the reply.

[AB33]

I noticed I made a mistake looping forward, instead of back word. Holger's comment alerted me.

[AB33]

"add 6 columns every other column beginning at column F"
To me means insert 6 columns every other columns(Jump) one column, starting from column 6.

[tehneXus]

AB33, I agree.

Please Login or Register  to view this content.