Assigning range to 2D array: subscript out of range

Objective: to load 700 X 2 range into an array. This array is thereafter loaded to a 2 column listbox which will be used to select the row in listbox and copy selected listbox value into a particular cell.

Error line is in red. This code is within Userform_initialize procedure.

What has been tried and tested?

1. Using Immediate Window, I have found values for prj(1,1), prj(2,1) etc. to be valid and consistent with table.

2. Ubound and Lbound is correct for row and col's start and end.

Please Login or Register  to view this content.

As you have declared dataArr as a one based array it should be

Please Login or Register  to view this content.

Originally Posted by Fluff13

As you have declared dataArr as a one based array it should be

Please Login or Register  to view this content.

Aye, this was the problem after all. What do you mean by one based array? Also, I found using Dim dataArr instead of Dim dataArr() seems to done the trick, I am not sure but it seems confusing to me as I learnt arrays need to be declared with parenthesis.

This was the most nonsensical thing I have learnt today:

Please Login or Register  to view this content.

This should work

Please Login or Register  to view this content.

Originally Posted by Fluff13

This should work

Please Login or Register  to view this content.

Yes it worked. Please explain difference in prjs.value and assigning prjs to another variable.

Do you know of any good resource on this, I may need to read up to clarify my basics. Much appreciated.

When assigning a range to an array it will automatically use the range value, but not when assigning it to the List property of a listbox. Although I have no idea why.

Originally Posted by Fluff13

When assigning a range to an array it will automatically use the range value, but not when assigning it to the List property of a listbox. Although I have no idea why.

Thanks solved.

Glad to help & thanks for the feedback.