J
John Wirt
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
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