I am looking for a way to use autosave in VBA if an evolving numeric condition is met. Basically, I am looping through a variable called 'input_row' and I would like to use a condition that tests whether that variable is a multiple of 25 for instance:
If input_row = (random integer) * 25 Then ActiveWorkbook.AutoSave End If
Given that my code is constantly crashing due to issues with IE8, as discussed here, here making sure to autosave now and then seems pretty important. At the moment I am saving after every iteration in my loop which works fine but slows down the entire process quite a bit.
Any simple 'if' statement suggestion?