excel2003 how to minimize DIM

[nodari]

Hi

I have DIM like this:

Private Type mtype
. . .
ncase (0 To 10, 0 To 420) As Integer
group as byte
. . .
End Type

dim m(0 to 10000) as mtype

this DIM makes memory problem and I need to decrease used memory somehow. I hope possible, as the .ncase is needed only when the meaning of .group is 11 or 12. in any other case, I don't need the .ncase at all.

how can I do so, that .ncase take memory only when it is neccessary.

 

[doofusboy]

Sorry i don't have the time to answer fully right now, but if you look into Redim, you may find it is what you need. It allows you to redimension as needed.