LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Scope of Variables leerem Excel Discussion (Misc queries) 4 September 30th 08 12:54 PM
Public variables and scope Dennis Benjamin Excel Programming 3 December 2nd 05 04:41 AM
VERY Basic Define Variables Help Needed BEEJAY Excel Programming 12 September 30th 05 08:10 PM
Scope of variables Purnima Excel Programming 1 April 5th 05 05:59 AM
clarification Michael Joe Excel Programming 3 August 13th 04 09:49 PM


All times are GMT +1. The time now is 09:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"