Repeat a column Insert in the same position on two other sheets.

[pcarmour]

Hi,

After inserting a column which may be anywhere on a worksheet I want to copy the new column with its heading and insert it in exactly the same position on two other worksheets. For example I will insert a column 'H' and give it the heading LONDON I then want to copy this column and insert it as column 'H' on two other worksheets (Called Placing_Record and Year_Summary), whichever column I originally insert I want to repeat but it will not always be 'H'
I am working with Windows Home Premium version 6.1.7601 SP 1 Build 7601and Excel version 14.0.6123.5001 (32 bit)

[jmutsche]

nvm

[jmutsche]

Selection.Copy
Sheets(Array("Sheet1", "Sheet2", "Sheet3")).Select
Sheets("Sheet1").Activate
ActiveSheet.Paste
Sheets("Sheet2").Select
ActiveSheet.Paste
Sheets("Sheet3").Select
ActiveSheet.Paste
Application.CutCopyMode = False

that should work for 2 sheets

[jmutsche]

just select the column you want and run it.

[pcarmour]

Hi jmutsche,

Brilliant exactly what I want, thank you very much, VBAX really is the place to get answers from the experts!