Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
storing macros ? | Excel Discussion (Misc queries) | |||
Storing a value to variable | Excel Discussion (Misc queries) | |||
storing value's | Excel Programming | |||
storing of VBA code | Excel Programming | |||
Storing Data in code? (relative primes to MOD as example) | Excel Programming |