I appreciate the help. I have a loop routine in a large spreadsheet that takes a while to run. Mostly due to the size of the worksheet itself but I'm looking for ways to speed it up, like turning the screenupdating = false. However due to the length of the routine (taking anywhere from 15-30mins), I wanted to create a periodic screenupdate. I've placed it inside an If statement nestled in a loop but its not engaging and I don't know why. I should add that if I add a simple msgbox w/ the screenupdate, it'll work as intended.
Thank you for anyone's time put into trying to help me here.
Code
Sub ScreenUpdate()
Dim i as integer
Application.ScreenUpdating = False
N=10
Do While i < 300
< Normal Code Routine >
IterationCount = i
If IterationCount Mod N = 0 Then
Application.ScreenUpdating = True
Else
End If
Application.ScreenUpdating = False
i=i+1
Loop
Application.ScreenUpdating = True
End Sub
Display More