Thank you Kevin.
I've chosen the global variable on startup because the last month doesn't change today. So for me there is no need to calc it again with every macro i use it in.
Now we have november 15th. The last month will not change in the next two weeks - no matter how often this variable will be recalculated until december 1st.
So for me it is enough if this variable is calculated once a day when i fire up my PC and get to work.
Hmmmm... maybe it should be better declared as constant
I've chosen the global variable on startup because the last month doesn't change today. So for me there is no need to calc it again with every macro i use it in.
Now we have november 15th. The last month will not change in the next two weeks - no matter how often this variable will be recalculated until december 1st.
So for me it is enough if this variable is calculated once a day when i fire up my PC and get to work.
Hmmmm... maybe it should be better declared as constant