I have a worksheet that I use as a "template" - layout, formatted correctly,
etc.. When I start my macro I copy that template to a working worksheet
where I start to populate data, formulas. The template has named ranges in
it. When I copy it I get a message asking me to copy teh named range, or
point to another reference soemwhere on my computer ... isn;t there an option
to override that and just accept the YES option for each named range when
copying a worksheet?