VBA - For i= 1 To "value in a cell XY"

[jaspalsd]

Hi,

I wish to define the limit for i in a loop by referencing a calculated value within a cell.

I could use the lastRow method in order to determine when to end the loop but is there a way to say for example:

"For i = 6 To (value in cell A2)" or must it be manually typed within the code? I am able to determine what the limit (last row) is using a calculation when my range changes for the list of items.

No problems if it is too much work as I have previously used code that stops at the LastRow of text.
Thanks,

Jas

 

[nemmi69]

All you need is to get the value

Dim EndLp As Integer
EndLp = Worksheets("Sheet1").Range("I1").Value

then For i = 6 to EndLp

 

[KOKOSEK]

For i = 6 to Worksheets("Sheet1").Range("[B]A2[/B]").Value
' your code
Next i

 

[jaspalsd]

For i = 6 to Worksheets("Sheet1").Range("[B]A2[/B]").Value
' your code
Next i

Many thanks to both!

I wish all code was as simple as that

Much appreciated!