Loop and Locals window

Hi Qasim,

Thank you for the forum question.

Yes if you use a For Next loop For x=1 to 10, it will count to 11.

The logic is that you type the line For x=1 to 10 above the code you want to loop trough. When you step the code (F8) you can see in the Locals Window, that you add 1 to x every time you reach the line Next x. When you have 10 in x you still want to run the lines
under the line For x=1 to 10 one more time (it will be the tenth time). When you get to the line Next x you will get x=11 and the loop will stop.

I hope this makes sense.

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector