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
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
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
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
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
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