Variable that retains value after closing excel

[Sandy]

Is it possible to force a variable to retain its value after closing excel.
In other words when excel is opened next time the value of the variable at
close is retained?
Sandy

 

[Don Guillett]

One way is to store in a cell somewhere

 

[Norman Jones]

Hi Sandy,

Amongst a number of possibilities, you could write the variable's value to a
defined name in the Workbook_BeforeClose procedure and read it in the
Workbook_Open event; alternatively, you could write the value to a (hidden?)
sheet. Other possibilites would include wtiting the value to the registry or
a Workbook property.