Sub Delete Blank Rows1() 'Deletes the entire row within the selection if the ENTIRE row contains no data.
'We use Long in case they have over 32,767 rows selected. Screen Updating = False 'We work backwards because we are deleting rows.
If you have a large spreadsheet with complex formulas or formulas linked to separate workbooks, this can really slow down a macro.
This means that if you make an error and then correct it, the keystrokes required to complete those actions also will be recorded in your macro code.
If you have played around a bit with macros or dabbled in VBA code, you might have heard of the to False at the start of a macro, you will not only stop the constant screen flicker associated with a recorded macro, but also speed up the macro's execution.
In some examples we turn off Calculation and Screenupdating.
The reason we turn off calculation is in case the range in which we are deleting rows contains lots of formulas, if it does Excel may need to recalculate each time a row is deleted, slowing down the macro.
Below are 6 methods that will delete rows from within a selection.
If you know the range you can replace "Selection" with your Range(). Screen Updating = True End With End Sub Sub Delete Blank Rows2() 'Deletes the entire row within the selection if _ some of the cells WITHIN THE SELECTION contain no data. I need help in diagnosing and resolving this issue.on occasion i run into similar issues, usually caused by one process not completing before the macro continues, thus leaving something out of place (line breaks actually help the issue because it gives the process a chance to complete). Generally, when previously using Excel 2007, a user clicks a button and everything works as expected (calculations, some email sending & file I/O).Typically, the expected run-time is about 90 seconds.It is important to note that the least efficient methods involve those that use loops.