Hi Rick,

Thanks for the feedback.
The workbooks i use are done weekly, with the week commencing date always being the monday, i have created almost the entire years worth of sheets so would like to avoid re doing them all.
I guess i would like a macro that will look at the active workbook and name the ranges i need.

For any new sheets created i am using a template method, and copy->pasting the sheet, changing the name and job done.