For....Next loop code required
 

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

--
Message posted from http://www.ExcelForum.com

For....Next loop code required
 

Best to try here first. A better learning experience for all.

--
Don Guillett
SalesAid Software

"uplink600 " wrote in message
...
Hi

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

Thanks

VC


---
Message posted from http://www.ExcelForum.com/

For....Next loop code required
 

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



-----Original Message-----
Hi

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

Thanks

VC


---
Message posted from http://www.ExcelForum.com/

.