Re: Free old variables
Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance
Erase ArrayName
--
Jim
"Jeff" <Jeff@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:F6FA1638-502B-4352-AE4E-53999F54C14B@xxxxxxxxxxxxxxxx
| Hi,
|
| I have a macro that I run am running - here is the problem.
|
| I have an array of values that is populated in the macro. It is a public
| variable and I cannot make it local. When I rerun the array keeps its old
| values.
|
| Question - is there anyway to zero out the array again - I was just using
| the loop at the beginning of the macro
| For i =1 to 100
| array(i) =0
| Next i
|
| ... but is there a better way?
|
| Thanks for your help
.
Relevant Pages
- Array and Struct Constants in MASM
... compile-time array and structure constants. ... Syntax (used as a macro function): ... This macro creates a MASM struct declaration and also creates ...
(alt.lang.asm) - Re: Macro running slow
... ' Macro to return heights of Rows 1-6 to their preset heights ... But I have to question why row heights need to be adjusted in a macro. ... read the range into an array and loop through the ...
(microsoft.public.excel) - Re: Help end the testing tedium please
... The new macro is crashing at: ... The filename and sheet name look fine. ... two arguments needed for "Consolidate". ... the file really were test1 thru test60, would the array statement need ...
(microsoft.public.excel.programming) - Re: Q re program speed, with 15k lines of data
... i didn't attribute much to the vlookup when the macro ... before the loop, not auotmatic as i stated in my firt post. ... Maybe what can speed this up is putting the data in an array, ...
(microsoft.public.excel.programming) - Re: Is it possible to run a macro in tandem with, or right after,
... macro, or by having one macro call several others that each perform one piece ... 'sub procedure can access the rowHgts array from this ... Dim rowRng As Range ... Dim outputRow As Long ...
(microsoft.public.excel.programming) |
|
