MOD statement ....

[sal21]

Hans... lost the code to save workbook for each 200 iteraction of RIGA, remember...

i use the counter RIGA=RIGA+1

now i want to save avtive workbook for each iteraction of RIGA=200

for example:

riga=200
save workbook
...
riga=400
save workbook

ecc....

[HansV]

Does this do what you want?

Code: Select all

If RIGA Mod 200 = 0 Then
  ActiveWorkbook.Save
End If

[sal21]

Does this do what you want?

Code: Select all

If RIGA Mod 200 = 0 Then
  ActiveWorkbook.Save
End If

work naturally!