Hi,
I have different sheets that use a cell named "RngYear" to calculate dates. So when I change RngYear from 2018 to 2019, all dates are updated
To do so, I have a dropdowdown menu in my ribbon that change the value Range("RngYear") with the value of the dropdown
What annoys me is to have that cell "RngYear" in my workbook. Instead, can I not write the value in the "backstage" (a constant "CstYear" that would change when I update the dropdown) and that I could call from a formula such as
?
Thanks in advance for your help
I have different sheets that use a cell named "RngYear" to calculate dates. So when I change RngYear from 2018 to 2019, all dates are updated
Code:
=Date(RngYear,A1,B1)[/FONT][/COLOR][COLOR=#222222][FONT=Verdana]
What annoys me is to have that cell "RngYear" in my workbook. Instead, can I not write the value in the "backstage" (a constant "CstYear" that would change when I update the dropdown) and that I could call from a formula such as
Code:
=Date(CstYear,A1,B1)[/FONT][/COLOR][COLOR=#222222][FONT=Verdana]
Thanks in advance for your help