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
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