I am using code to copy one sheet from a masterfile to varios workbooks in a
folder. Problem is when it copies the sheet over, the named ranges link back
to the sourcebook, when I need them to relate to the new book. How can I do
this with code?
Appreciate all replies.