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

 

[BrianB]

Code
-------------------

x = Worksheets("Sheet1").Range("A1").Value
For n = 1 To x
'- etc

-------------------

 

[Guest]

Hi Brian

Only 1 line, I was expecting 3 or 4 lines <g>

Thank You

Regards Bob C

 

[Bob Phillips]

even less vbg>

For n = 1 To Worksheets("Sheet1").Range("A1").Value
'- etc



--

HTH

RP

Hi Brian

Only 1 line, I was expecting 3 or 4 lines <g>

Thank You

Regards Bob C

 

[Guest]

Hi Bob

I'm trying to get the hang of this excel and you and Tom Ogilvy keep moving
the goal posts <vbg>

neat very neat
Thanks
regards Bob C

even less vbg>

For n = 1 To Worksheets("Sheet1").Range("A1").Value
'- etc



--

HTH

RP

Hi Brian

Only 1 line, I was expecting 3 or 4 lines <g>

Thank You

Regards Bob C

 

[Bob Phillips]

Hi Bob C,

You know what they say, stand still and you stagnate<vbg>. On your toes!

Bob