98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » For Loop
For Loop
Resolved · Low Priority · Version 2003
Thu 19 Feb 2009, 16:33Delegate Nick said...
Nick has attended:
Excel VBA Intro Intermediate course
Excel VBA Intro Intermediate course
Excel VBA Intro Intermediate course
Excel VBA Advanced course
For Loop
Please explain the function of X = 1 to 1 in relation to the for loop.....
Fri 27 Feb 2009, 15:21Trainer Carlos said...
RE: For Loop
Hi Nick
A loop gets Excel to repeat a piece of code a certain number of times.
The number of times the code gets repeated can be specified as a fixed number (e.g. do this 10 times), or as a variable (e.g. do this for as many times as there are rows of data).
If you know, or can use code to find out, how many times to repeat a block of code you can use a For
Thu 5 Mar 2009: Automatically marked as resolved.
Training information:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Generating simple column charts1.Select cell range containing data/figures |
