A Loop does not loop throught. It stops after two cells.

**AB33** · 09-14-2012, 07:54 AM

I have relly got weird problem with the attached sheet. I set up a last row and try to loop through from 1 to last row. For some unknow reason, the last row shows the correct result,but when it loops throught, instead of looping from 1 to 24, the loop stops at 1, or 2. To test my syntax, I set up a different module and tests it using msgboxes. The magboxes show the corrrect result,but if I use the same syntax on the actual sheet, the loop stops at 1, or 2.

Please Login or Register  to view this content.

The last row, ie LR2 is 24, but when it loops from 1 to LR2, instead of giving the result of 1 to 24, I have got 1 to 1.
I am sure, There is an error on the above line, but having done a test, I am unable to see it. Please a person with eye for details help.

**TMS** · 09-14-2012, 08:24 AM

This first one works, but note the variable you use is not the same as the one you Dim:

Please Login or Register  to view this content.

Second one works fine. Third one works fine but, again, not the variable in the loop vs the variable Dimmed

Please Login or Register  to view this content.

This last one, copied from your post and edited counts from 1 to 24.

I'm not entirely sure what you're doing wrong. These all seem to work as expected, barring the incorrect variable usage. Use Option Explicit to avoid this issue.

Regards, TMS

**AB33** · 09-14-2012, 09:30 AM

Thanks TMS!
If I have now corrected the variable names. If you look at modules Test1 and test 2. There are 24 rows on column "B", but on test2 module, the loop returns 25. So,if the last row is 24 and you loop through from 1 to last row, I thought, you get 24 rows, not 25.

**TMS** · 09-14-2012, 09:55 AM

No. You increment X from 1 to LR (24) and it will drop out of the loop when X is greater than 24. 25 is greater than 24 so it drops out of the loop and displays X = 25 and LR = 24. It has to increment X in order to test it against the upper limit.

It's rare that you would want to do anything with X once it has served its purpose as a loop counter.

Regards, TMS