View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
vmegha vmegha is offline
external usenet poster
 
Posts: 13
Default 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