Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Load a static array at procedure level
I am using Office 2003 on Windows XP.
I am trying to load a static array with data as follows: At module level: Private msColTotals() as String In procedu ReDim msColTotals(7) msColTotals = Array("L", "X", "Y", "AA", "AB", "AF", "AJ") But this fails. Can someone please post example code to fix this so it will run? Thanks much in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup from Static List/Array | Excel Worksheet Functions | |||
keeping a sum array static | Excel Worksheet Functions | |||
Static and Dim outside procedure | Excel Programming | |||
Stopping a 'multi-level' procedure | Excel Programming | |||
Declaring array constants at module level | Excel Programming |