Clarification needed about Scope Of Variables
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
|