Hi everybody,

I am trying to insert a new column in sheet 1 with a macro and at the same time insert a new column in sheet2. I have used the following code:

Selection.EntireColumn.Insert
Sheets("Sheet2").Select
Selection.EntireColumn.Insert

However, I need the macro to place the column in sheet 2 in the same location as that in sheet 1. i.e. if I insert a new column after column F on sheet 1 a new column will be inserted at column F in sheet 2 and next time I may insert at column B and again need to have sheet 2 automatically insert a new column at this point. Can anyone help please?

Thank you

Garry