lines in loop don't execute when program is run

[akaron]

Hello,

I am working a program that is supposed to take a value the user inputs, search a database for it, and within all the entries that have that value, find another user input quality. I'm having trouble with my second loop. The code is below:

Please Login or Register  to view this content.

I'm not getting any compile or runtime errors, but while stepping through the program, I found that the program will correctly execute this line:

Please Login or Register  to view this content.

which is inside the first loop and outside of the second loop, but not this line of code:

Please Login or Register  to view this content.

and will therefore not perform any of the if statements after this line. After it executes the "For Row =" line, it goes directly to "if yes = false"

Any ideas why this could be happening?

[Tinbendr]

Row is a Excel reserve keyword. Try changing all references to iRow.

[akaron]

Thanks David, I made that change, but it is still skipping from the start of the loop to the if statement after it. Anything else I may not have thought of?

[Tinbendr]

Where is NumInFam initialized? (Or what is it?)

Setup Quick watch on several variables in the loop and see what value they get assigned.

[akaron]

Where is NumInFam initialized? (Or what is it?)

Setup Quick watch on several variables in the loop and see what value they get assigned.

NumInFam is initialized at the top of the module and it is a public variable. Here is the code:

Please Login or Register  to view this content.

Also, I've been watching the variables as I step through the program, and EngSizeEnter gets assigned the right value and dbEngSize doesn't even get assigned.

[JosephP]

what is the value of NumInFam when you run the code? if it's 0 then the inner loop won't run at all.

[Tinbendr]

In the Sub FindRowToInsert, and just before For Row = i To (i + (NumInFam - 1)), add

Please Login or Register  to view this content.

and see what it is returning. If it's less than 1, then that is your problem.

[akaron]

Tinbendr, Thank you so much for this useful tool!!! and JosephP, yes it's returning zero, so I guess I'll have to figure that one out. Thanks so much for your help!