Posted to microsoft.public.excel.programming

Les Gordon Les Gordon is offline

external usenet poster

Posts: 4

Public Variables

I have declared two Public variables to track various data. Eveything works
well until the systme crashes (in this case, which I will fix, because the
suggesated sheetname has more than 31 characters). Once it crashes the Public
variables loose their values and can't be reset; closing the workbook doesn't
help but restarting Excel does. Is this a scope problem; can I fix it in code?

Regards
--
Les Gordon

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 variables	johnny	Excel Discussion (Misc queries)	7	February 27th 08 03:44 PM
Public variables	johnny	Excel Discussion (Misc queries)	2	February 24th 08 05:05 AM
Public Variables	Jerry McNabb	Excel Discussion (Misc queries)	0	February 24th 08 01:26 AM
Declaring Variables Public	ob3ron02[_8_]	Excel Programming	1	October 25th 04 02:14 PM
Public variables and Class	Aidy	Excel Programming	1	April 8th 04 03:25 PM

All times are GMT +1. The time now is 04:41 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us