For....Next loop code required

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
 
G

Guest

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
 
Top