Redimension an array within a user typed array

[MacroManII]

How can I redimension the size of nQty, in the following
user defined array

Type UsageRecord
sPart As String * 5
bIsKIT As Boolean
sDesc As String * 30
nQTY(20) As Long
nDaysBooked As Integer
nTotal As Long
nMean As Double
nStdDev As Double
nShelfStock As Double
End Type

Dim deArray() as UsageRecord

Regards

MacroManII

 

[rdavis]

ReDim dearray(index).nQTY(count)

Replace 'index' with element index that you want to change and replace' count' to whatever you want the size of array to be.



Rob