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

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