I frequently need to use variables in a program €“ could be words or numbers €“
which are available for as long as the programme is running.
The programme may contain several modules some or all of which may be called
during execution.
To achieve this, I define a named range and store the variable value in it.
This is tedious. I believe I can define an enduring variable as something like
"Public MyVariable", but have had no success.
If Public is the right approach,
How is it written?
Where do I put that declaration?
Can it go in "This Workbook" or must it go in a module?
If I use "Public" do all my modules have to be "Sub Public" ?
Some enlightenment would be much appreciated.
--
donwb