Loops and arrays

I am working on an assignment for class. I am supposed to get 25 random numbers to appear in A1:E5, then using arrays and loops, I am supposed to get the same numbers to appear in cells F1:F25.
There are 3 parts to this assignment:
Part 1: fill cells A1:E5 with random integers between 0 - 99
Part 2: fill the two-dimensional array with the values of cells A1:E5
Part 3: fill cells F1:F25 from the two-dimensional array.
Here is my code followed by the issue I am having.

Please Login or Register  to view this content.

I keep getting a runtime error 9 and it highlights " intTwoDimArray(intRowIndex - 1, intColumnIndex - 1) = Cells(intRowIndex, Chr(64 + intColumnIndex))."'
Please help and any and all help is appreciated.

You loop from 0 to 4 in both your inner and outer loops but you subtract 1 from those indexes so, first time through, you will try to use element -1, -1

Regards, TMS

And your solution?

Regards, TMS

It is often the way that, when you explain your problem, you can see the solution for yourself.

And it's usually the best way

Regards, TMS



If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

Thanks for helping.

You're welcome. Thanks for the rep.