Loop variable subscript out of range

**maurice1991** · 06-01-2015, 06:06 AM

I can't discover what is wrong in my code.
ArraySeasonality(M) is constantly saying that the subscript is out of range, yet I let M (it was I before but I tried a different variable, still didn't work) loop from 0 to 3 and ArraySeasonality has 4 datapoints (0,1,2,3)
It is probably something I do wrong in the way I write the loops. When I remove the I=0 lines then the other variables show the subscript out of range as well.

Please Login or Register  to view this content.

**Richard Buttrey** · 06-01-2015, 06:13 AM

Hi, and welcome to the forum.

It would have been more useful if you had uploaded the workbook so that we can see the problem in context.

However I suspect it's probably because you have only dimmed the array as 3 despite you saying there are 4 values - and I can see no Redim instruction.

**maurice1991** · 06-01-2015, 07:14 AM

Thank you for your reaction.
However that can't be the problem can it? An array of 3 by default has 4 values? (0,1,2,3)
Anyway I fixed the problem by just changing all the if statements to do while statements, still a bit weird.

**Richard Buttrey** · 06-01-2015, 07:31 AM

Hi,

Depends on whether the Base is zero or one.

Loop variable subscript out of range

LinkBack

Thread Tools

Rate This Thread

Display

Loop variable subscript out of range

Re: Loop variable subscript out of range

Re: Loop variable subscript out of range

Re: Loop variable subscript out of range

Thread Information

Users Browsing this Thread

Similar Threads

Help reading For loop with range variable

Do Loop with variable range

Do Loop with Variable Range

[SOLVED] Select Sheets based on variable array -ERROR 9 Subscript out of range

Why did an inner loop variable start overwriting the outer loop range suddenly?

Bookmarks

Bookmarks

Posting Permissions