ExcelBanter - For Next Loop

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - For Next Loop (https://www.excelbanter.com/excel-programming/314109-next-loop.html)

Robert Christie[_3_]

For Next Loop

Hi all

Using Office Excel 2003 Sp1

When using the For i = 1 to 10
€˜Your code
Next i

Can the number 10 be obtained from a cells value on the same sheet or a
second sheet?
(a formula would produce the cells value of 10, 14, 25 etc..)

The value in the cell will not change while code is running.

--
Thank you

Regards

Bob C

Tom Ogilvy

For Next Loop

for i = 1 to Worksheets("Sheet1").Range("A1").value

Next

--
Regards,
Tom Ogilvy

"Robert Christie" wrote in message
...
Hi all

Using Office Excel 2003 Sp1

When using the For i = 1 to 10
'Your code'
Next i

Can the number 10 be obtained from a cells value on the same sheet or a
second sheet?
(a formula would produce the cells value of 10, 14, 25 etc..)

The value in the cell will not change while code is running.

--
Thank you

Regards

Bob C

All times are GMT +1. The time now is 02:29 AM.