Posted to microsoft.public.excel.programming

John Wirt[_12_] John Wirt[_12_] is offline

external usenet poster

Posts: 10

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Public variable	Jack	New Users to Excel	4	March 18th 06 09:35 PM
Declaring a Public variable as a Range and its lifetime	John Wirt[_5_]	Excel Programming	8	January 23rd 05 06:40 AM
scope/ lifetime of variable	jeffP	Excel Programming	5	September 19th 04 05:25 AM
scope/ lifetime of variable	Norman Jones	Excel Programming	0	September 18th 04 12:55 AM
module-level variable lifetime	Jessie[_2_]	Excel Programming	0	July 30th 03 09:31 PM

All times are GMT +1. The time now is 10:38 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us