Type Mismatch and Subscript out of Range for Static Array

I get 2 different types of errors depending on how I Dim my array. I selected 4 cells when I ran the code below and it throws the error, "subscript out of range" on "MyArray(i, 1) = 1", when i = 1.

Please Login or Register  to view this content.

Then when I ran the code by changing the () from the first line, I get Type Mismatch on the MyArray(i,1) line:

Please Login or Register  to view this content.

Help! I'm new to arrays and have read through a few tutorials but this is my first time trying one.

The original code worked fine for me with no changes.

Tried it once with a block of 30 cells and again with just one cell.

HTML Code: 

Please Login or Register  to view this content.

What are you selecting? What's the purpose of the routine?

Regards, TMS

No problem. We all make mistakes occasionally.