inserting new blank columns every nth column

[grantdowie]

Hello

I would like to add three new blank columns to an Excel spreadsheet using VBA after every 7 columns and I would very much appreciate any help to do this.

Thanks

Grant

 

[mikelee]

Hi Fluff

I just started leaning VBA by doing. This is really helpful.

I am trying to copy the formulas in the last non-blank column (e.g. column I, R, etc ) and paste them to the new inserted blank columns. I was trying to use the above codes and modify them.
It seems that I am already lost.

Can you help me with this?

Really appreciate your help!

Regards,
Mike

 

[Fluff]

It would be best if you started a new thread for your question, giving full details of what you are trying to do. Thanks