| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
resetting Public Arrays in VBASIC
I have an array that I'd like to zero out each time I run the macro in Excel.
What would be a simple way of doing that? -- Thanks! Max |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
resetting Public Arrays in VBASIC
Hi
You can use the Erase statement to reset the array in one shot. You'll have to Dim the array again before using it. (See online help for Erase). -- Regards, Sébastien <http://www.ondemandanalysis.com "Max" wrote: I have an array that I'd like to zero out each time I run the macro in Excel. What would be a simple way of doing that? -- Thanks! Max |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 'spin buttons' & vbasic language | Excel Discussion (Misc queries) | |||
| Select item in drop-down list in Vbasic | Excel Programming | |||
| Clearing public arrays | Excel Programming | |||
| Formula in VBasic | Excel Discussion (Misc queries) | |||
| Array of Public Arrays | Excel Programming | |||
Hybrid Mode
