What is lifetime of public variable?

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

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" <mmm@toward.com> wrote in message
news:eqe3$dqOGHA.2036@TK2MSFTNGP14.phx.gbl...
> 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
>
>
>

Thank you, Bob.
John

John,

I presume this is related to your previous post about ranges and stacks.
If you store the "collection of ranges" as normal strings then you can save
them in Personal.xls. See my reply to implementing stacks in Personal.xls,
in your prev post.

Regards,
Antonio Elinon

"John Wirt" wrote:

> 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
>
>
>
>

Thank you, Antonio.
John
>