Thanks for the above info.
the code i am using is very basic. I am trying to enter the new column as the new column A
What I am finding is that when i run the macro it is extracting the info from the wrong column. eg what was column B in the original macro is now column C,
With the sheet I am trying to insert the column into (master) , there are Macros with in that sheet which feed off info. and also other sheets have macros which feed of it.
other sheets which extract info from master are: template, club champos , finish positions