Yes it is there as long as that workbook is open, or something else happens
that clears it. it can't be as long as Excel is open, as the workbook could
be closed before Excel and it is defined in the workbook.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"John Wirt" wrote in message
...
What is the lifetime of a Public variable?

Does it hold the variableas long as the Workbook remains open?

As long as Excel remains open? Suppose the Public vaiable is declared in
Personal.xls?

I need a means of making a variable that is a collection of ranges
"permanent"--that is, the variable lasts as long as the workbook stays
open
at least.

Thank you.

John Wirt