One way is to store in a cell somewhere

--
Don Guillett
SalesAid Software

"Sandy" wrote in message
...
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