loops

[navyaa]

I need to put this is in a loop, i was thinkin of using the for loop but dont know if i can use a name range in the loop( eg when i say from i=0 to [range name])


If [RPTDT] > [RPTCHK] Then
Call RPTCK2
If [RPTCNT] >= [CURCNT] Then
Call QTRPT
Else
[RPTCNT] = [RPTCNT] + 1
Calculate
ActiveCell.Offset(rowOffset:=1,
columnOffset:=0).Activate
End If

 

[hedrijw]

If you have a cell named times_to_loop then you can:

For i = 1 To [times_to_loop]

' ----- Your Code Goes Here ---

Next

or alternatively:

For i = 1 To Range("times_to_loop")

' ----- Your Code Goes Here ---

Next

 

[navyaa]

Thank you for your help...

will try it and see if its works for me

navya.