Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I always thought that Variables Live till the end of the Sub / Function and get deferenced at the end of the procedure. But I saw this tip on a website, that within a sub, dereferences a locally created variable to Nothing. I'm now in doubt if I should be doing that in my procedures, since I have some heavy variables too And any suggestion for maintaining global constants in VBA, I have created these strings that wont die till the Application closes Thanks, Megha |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Scope of Variables | Excel Discussion (Misc queries) | |||
Public variables and scope | Excel Programming | |||
VERY Basic Define Variables Help Needed | Excel Programming | |||
Scope of variables | Excel Programming | |||
clarification | Excel Programming |