Look like a cool new forum! I'm developing an Outlook 2003 VBA application. The app contains (so far) 3 custom forms.

There are three multi-dimension arrays I need to make Public to the entire app. I get the following error when I declare the Public array:

Compile Error:
Constants, fixed-length strings, arrays, user-defined types and Declare statements not allowed as Public members of object modules.

Here is how I am trying to declare the array:


'These CONSTs define the MAX values of rows and columns in the arrayRenewalDates array
Const MAXROWS_RENEWAL_DATES = 6
Const MAXCOLS_RENEWAL_DATES = 2

Public arrayRenewalDates(1 To MAXROWS_RENEWAL_DATES, 1 To MAXCOLS_RENEWAL_DATES) As Variant

What am I doing wrong?

Thanks,
James