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

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

2017-02-09 Thread wltrpscl
Is it possible in an Excel workbook as long as it is open, to keep active in memory variables, array variables? And those, when running a program / script vba or macro is finished. How to declare variables, array variables? -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna