m_in_spain
Board Regular
- Joined
- Sep 28, 2018
- Messages
- 64
- Office Version
- 365
- Platform
- Windows
Hi,
I have a named cell on sheet Commercial! at F17 called "Warranty". When i finish and run my project that figure is used in various claculations, the updated workbook is saved as a macro free xlsx file.
My enduser may need to change the "warranty" Figure, however my original sheet containing that will be very hidden.
Is there a way using VBA to change the refers to for the name "Warranty" from =Commercial!$F$17 to =TCJ!$G$47
I can't for the life of me think how to phrase this to search in here or indeed even in Google for this answer
Any help, as ever, will be much appreciated
I have a named cell on sheet Commercial! at F17 called "Warranty". When i finish and run my project that figure is used in various claculations, the updated workbook is saved as a macro free xlsx file.
My enduser may need to change the "warranty" Figure, however my original sheet containing that will be very hidden.
Is there a way using VBA to change the refers to for the name "Warranty" from =Commercial!$F$17 to =TCJ!$G$47
I can't for the life of me think how to phrase this to search in here or indeed even in Google for this answer
Any help, as ever, will be much appreciated