Re: $$Excel-Macros$$ keep active in memory variables, array variables

2017-02-09 Thread spainy via MS EXCEL AND VBA MACROS
On Thu, 2/9/17, libertystringer via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ keep active in memory variables, array variables To: excel-macros@googlegroups.com Date: Thursday, February 9, 2017, 9:09 PM

Re: $$Excel-Macros$$ keep active in memory variables, array variables

2017-02-09 Thread storeythomas725 via MS EXCEL AND VBA MACROS
On Thu, 2/9/17, libertystringer via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ keep active in memory variables, array variables To: excel-macros@googlegroups.com Date: Thursday, February 9, 2017, 9:09 PM

Re: $$Excel-Macros$$ keep active in memory variables, array variables

2017-02-09 Thread libertystringer via MS EXCEL AND VBA MACROS
On Thu, 2/9/17, martinez.david533 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ keep active in memory variables, array variables To: excel-macros@googlegroups.com Date: Thursday, February 9, 2017, 9:05 PM

Re: $$Excel-Macros$$ keep active in memory variables, array variables

2017-02-09 Thread martinez.david533 via MS EXCEL AND VBA MACROS
On Thu, 2/9/17, keisha.fry via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ keep active in memory variables, array variables To: excel-macros@googlegroups.com Date: Thursday, February 9, 2017, 7:02 PM

Re: $$Excel-Macros$$ keep active in memory variables, array variables

2017-02-09 Thread keisha.fry via MS EXCEL AND VBA MACROS
On Thu, 2/9/17, Paul Schreiner wrote: Subject: Re: $$Excel-Macros$$ keep active in memory variables, array variables To: "excel-macros@googlegroups.com" Date: Thursday, February 9, 2017, 6:56 PM The answer is:Yes. The long vers

Re: $$Excel-Macros$$ keep active in memory variables, array variables

2017-02-09 Thread Paul Schreiner
The answer is:Yes. The long version of the answer involves describing the "scope" of variables. First of all,in each VBA module, I recommend using Option Explicit as the first line of the module.This forces the compiler to check that all variables are EXPLICITLY declared.without it, the first tim