Insert new column on multiple sheets

Hi
I'm trying to insert a blank column on all the sheets except one. The column in question is not fixed, so i have created a Dynamic named range to define it.
The code that i have come up with so far is the following:

Please Login or Register  to view this content.

For some reason, no doubt completely obvious!, it seems to insert all the columns on one sheet as oppposed to one column on all the sheets.

thanks for your time

Hi

You need to select Sheet(i) before you insert the column:

Please Login or Register  to view this content.