Insert new blank columns using VBA after every nth column and then copy the formula to these New Columns

[mikelee]

Hi ,

I would like to add a few new Columns based on a Cell value (,e.g. Cell B2) to 4 Excel worksheets using VBA after every nth column and then copy the formula in the last columns and paste the formulas to the new blank columns .

E.g. insert 7 new columns from columns I and then copy formulas in Column H and paste formulas in column H to the new inserted columns. Would appreciate any help and guidance you can provide!

Thanks a lot!

Mike