For Next Loop

[Guest]

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 i = 1 to Worksheets("Sheet1").Range("A1").value


Next