storing a value in code
NEWBIE question:
I run code that retrieves an integer value 'hidden' in a cell on one of my
worksheets. The code uses thus value, then increments it by 1 before
storing the new value back in the 'hidden' cell. Next time I run the code,
it uses the incremented value even if I've closed and reopened the
application. All works well, but....
I'd rather store the value in the code, not in the 'hidden' cell. (so I can
better disallow certain values and manipulate other ones.) How can I store
the value in the code so that it increments as desired but doesn't reset
everytime I open the application?
much thanks
Ginger
|