A97: What's a workable substitute for Dim Thing(0 to intMyCount)?

[MLH]

How can I accomplish what I'm obviously trying to
do below in a Sub procedure?

Select Case CustomerCount
Case Is < 10
Dim My_Targets(0 To 10) As String
Case Is < 50
Dim My_Targets(0 To 50) As String
Case Is < 100
Dim My_Targets(0 To 100) As String
Case Is < 200
Dim My_Targets(0 To 200) As String
Case Is < 400
Dim My_Targets(0 To 400) As String
End Select

The array declaration won't accept a variable. I don't KNOW
what the upper bound is, so I have to do a recordcount and
assign it to a variable. VBA seems to think I'm trying to Dim
the array 5 different times. Of course, I'm not. If its unclear
what I wanna do, will try to elaborate.

[pietlinden]

ReDim Statement
Used at procedure level to reallocate storage space for dynamic array
variables.

Syntax

ReDim [Preserve] varname(subscripts) [As type] [, varname(subscripts)
[As type]] . . .

The ReDim statement syntax has these parts:
.....
straight out of the help file. You can even get to it by searching on
Dim... How 'bout that?

dim the array to whatever size (probably small) then redim it when you
know how big the array really needs to be.

[Tom van Stiphout]

On 11 Oct 2006 16:21:02 -0700, pi********@hotmail.com wrote:

And when you're done clean up such dynamic memory with the Erase
statement.
-Tom.

>ReDim Statement
Used at procedure level to reallocate storage space for dynamic array
variables.

Syntax

ReDim [Preserve] varname(subscripts) [As type] [, varname(subscripts)
[As type]] . . .

The ReDim statement syntax has these parts:
....
straight out of the help file. You can even get to it by searching on
Dim... How 'bout that?

dim the array to whatever size (probably small) then redim it when you
know how big the array really needs to be.