Error 92: For Loop Not Initialized - It worked before??

[djdave022002]

Morning,
I'm having an issue with the below code, i did work once, but suddently gave the error in the title on the For loop starting "For Each family In families()". i cant figure it out, after googling people suggested using option Explicit, which i have but it still doesnt work, ive declared all variables also. Strangely, it does give the result i want it to, but i just get this error every time ??

Please Login or Register  to view this content.

[Colin Legg]

Hi,

but i just get this error every time ??

Let's look at this line of code:

Please Login or Register  to view this content.

It's sitting inside a sequence of If...End If blocks, which means that it will only be called when certain conditions are met.

families is a dynamic array. If the ReDim statement isn't called then families is not dimensioned. If it isn't dimensioned then you can't use a For Each... Next loop to iterate through it, so you get that "For Loop Not Initialized" runtime error. Here is a simple example to illustrate:

Please Login or Register  to view this content.

So, you essentially have two options to fix the problem. You could either restructure your code to ensure ReDim is called, or you could devise a test to ensure that the array has been dimensioned. (larger code re-write or errorhandling are also options).

[djdave022002]

Thanks Colin, but i also get this error when i know the Array has been re-dimensioned as it outputs the data from the array ?

[Colin Legg]

Hi - can you attach an example for us to see?

[djdave022002]

Upload feature of forum is bugging out. ive placed it on my webserver, see link below.

ftp://ftp.davidjlittle.co.uk/htdocs/downloads/TMP condensed daves calc NEW.xlsm

[Colin Legg]

When I click on your link I get this:

Matrix FTP server ready.
This is a private system - No anonymous login
IPv6 connections are also welcome on this server.

I could rewrite the code, but I would prefer to help you to understand why you are getting the error.

[djdave022002]

Buggy upload wont let me attach the file even though its well within file limit for Zip