I’ve seen the threads on this subject that recommend “fiddling with the code” or “calling the code in a subroutine”.
Here is currently what my code looks like: Sub find Row() Application. Screen Updating is turned on outside of the procedure. - Try this at the beginning of your procedure: This solved my flicker problem, but I didn't like how the excel application disappeared completely then suddenly reappeared for the user. Calculation = xl Calculation Automatic 'to reset all formula calcs before deleting source Main Wrk Bk. Paste Special Paste:=xl Paste Values, _ Operation:=xl None, Skip Blanks:=False, Transpose:=False Application.