For....Next loop code required

  • Thread starter Thread starter uplink600
  • Start date Start date
U

uplink600

Hi

I need some help with the syntax on a 'for..next' loop on a worksheet
have prepared. Is it possible for me to email someone the actual .xl
file to make the problem easier to understand. If not I will try an
explain the problem here.

Thanks

V
 
Hi
the syntax is as follows:

For i = 1 To 100
'(what you want to repeat)
Next

the i is the variable whose value will be varied.
It will start at 1 and increase to a 100
The next statement increase the i variable and move
to top of for loop.
The 1 and 100 and i can be named anything.
Hope this help.
L
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

for next loop question 3
Worksheets in Loop 1
For-next loop question 6
Ground loop isolator causes loss of audio signal 9
Next Loop 10
Loop is slow trying array code 17
Help with For..Next Loop 4
variable number of For Next loops 3

Back
Top