[RESOLVED] assign variable to array size

[marktheman]

HI,
I have done this in VB6 but it is possible to assign a variable created to an array size in VBA?
Say'
Dim maxtblApproverRecords As Integer
maxtblApproverRecords = 7
Dim approverNames(maxtblApproverRecords - 1) As Variant
It keeps getting me "constant expression expected". How do I do it otherwise?
Thanks.