Named Ranges

[How_Do_I]

Is there an easy way to do this please…<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o> </o>
I have 11 workbooks each with 10 problem named ranges…<o></o>
<o> </o>
All the named ranges refer to the same ranges…<o></o>
<o> </o>
All my ranges need to be extended by a column so Table1Home which currently =Stats!$D$13:$AA$26 needs to be =Stats!$D$13:$AB$26<o></o>
<o> </o>
In case this helps the named ranges are:<o></o>

Excel Workbook
	F	G
4	Table1Home	Table1Away
5	Table2Home	Table2Away
6	Table3Home	Table3Away
7	Table4Home	Table4Away
8	Table5Home	Table5Away
Sheet1

 

[JoeMo]

If you can insert the column somewhere between column D and column AA, the named range will adjust automatically.

 

[How_Do_I]

I don't think I can, my range is already full of formulas...

 

[JoeMo]

If you insert an entire column, the formulas will adjust. Make a copy of one workbook and give it a try.