Start Turn off screen updating

Turn off screen updating

I started to debug, and immediately after the "Screen Updating = false" line executes, I go to the immediate window and type: Debug. Any clues on how to solve it would be greatly appreciated. Screen Updating = True End Sub _________________________________________________________ Private Sub Check_for_Open_Workbook() Application.

It is also much easier to keep track of your place, because you don't have to adjust the "current" row number to account for the deleted row. If you do that, be sure that not only is the visible setting at the end of your sub but that it also is used as part of some error handling routine.

Otherwise, the users may have issues if something unusual occurs. Visible = False application.visible=true" id="ctl00_m_m_i_ctl00_gr_ctl07_bestanswerbody" class="textarea-bestanswerhidden" name="bestanswerbody" answerbody Id="4587847" / In addition to turning off your screen updating, which was already addressed, if you have a lot of formulas, you may want to turn off your calculations, setting them to manual before the row deletions and then automatic afterwards.

It is also much easier to keep track of your place, because you don't have to adjust the "current" row number to account for the deleted row. Meyers-Jouan" id="ctl00_m_m_i_ctl00_gr_ctl03_bestanswerbody" class="textarea-bestanswerhidden" name="bestanswerbody" answerbody Id="4586392" / Shirley, You may also find that your code is running a bit slower than possible because each time you delete a row, everything below that point is being moved up -- when you delete the lowest numbered rows rows below that need to be moved. Calculation = xl Automatic You can also make the Excel app invisible.

If you reverse the order of the deletions (typically, change a for i = 1 to n loop to a for i = n to 1 step -1), each compaction works with fewer rows. Of course, that may also affect any other workbooks already open on your desktop.

I would like the queries to be invisible while they are running, but currently the user sees 50 query windows open/close which is ugly.

Is there a way to automatically minimize/hide query windows or disable screen update?

Otherwise, each time a row is deleted, all formulas will be recalculated, which may slow down things: Application. Calculation = xl Automatic You can also make the Excel app invisible.