Afternoon all,

I have a for loop that is initialised but then needs to
change the value for the number of loops:

#########################
For iQaRunDbaseSheet = 1 To (iArraySize + 1)

............

If i 1 Then
iMaxSheet = Worksheets.Count
Worksheets.Add after:=Sheets(iMaxSheet)
iArraySize = iArraySize + 1
End If

#################################################

Whilst the actual variable changes its value, the for loop
only executes the number of times that was initially
assigned to it. Is there anyway I can get the for loop to
run the number of times i want it to rather than the
initial value ?

Thanks,

Mike.