Hi there,
I'm using type to store data in my VBA code. I start with the usual declaration:
I then assign a variable to this type:Type BeamType TotNo As Long No(200) As Long End Type
How do I change the array size in my code though, I tried ReDim like:Dim Beams As BeamType
But that just produces an error.ReDim Preserve Beams.No(1 To 20) As Long
Any Ideas?