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....
MOD statement ....
-
- Administrator
- Posts: 78658
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: MOD statement ....
Does this do what you want?
Code: Select all
If RIGA Mod 200 = 0 Then
ActiveWorkbook.Save
End If
Best wishes,
Hans
Hans
-
- PlatinumLounger
- Posts: 4376
- Joined: 26 Apr 2010, 17:36
Re: MOD statement ....
work naturally!HansV wrote:Does this do what you want?
Code: Select all
If RIGA Mod 200 = 0 Then ActiveWorkbook.Save End If