Subscript out of range (error 9)

[jdfjab]

Someday, I’d love to be able to “help” someone else on the forum, but when one is this inexperienced one answer almost immediately leads to the next question, so… What is causing my subscript out of range (error 9) at line 82? I created the first UDT array element at line 56 and am trying to re-dimension with redim preserve to load the rest of the array.

Please Login or Register  to view this content.

Example.xlsm

[shg]

See Help for the proper syntax of the ReDim statement.

[jdfjab]

Shg,

I tried this after reading through the help, but guess I'm not understanding it as I still get the same error.

Please Login or Register  to view this content.

Does it have to do with there being the two different data types in my UDT?

[shg]

Help has its share of problems, but it's still an invaluable resource and you need to learn to use it.

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

The ReDim statement syntax has these parts:

Preserve Optional. Keyword used to preserve the data in an existing array when you change the size of the last dimension.

varname Required. Name of the variable; follows standard variable naming conventions.

subscripts Required. Dimensions of an array variable; up to 60 multiple dimensions may be declared. The subscripts argument uses the following syntax: [lower To] upper [,[lower To] upper] . . .

[JosephP]

if you need a hint

Please Login or Register  to view this content.

is not the same as

Please Login or Register  to view this content.

the first is a two dimensional array.

[jdfjab]

Thanks Shg,

This worked:

Please Login or Register  to view this content.

It's sometimes difficult for us newbies to read "tech-nise".
Thanks for pointing it out in the "help".

[jdfjab]

Thanks JP,
It took a long stare at the help