ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Named ranges and links (https://www.excelbanter.com/excel-programming/404970-named-ranges-links.html)

General[_2_]

Named ranges and links
 
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.


All times are GMT +1. The time now is 08:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com