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.