I ran Gurs benchmark on my desktop PC with Excel 2003 to Excel 2013., with a constant screen area visible (rows 8 and columns A: BF).
Since I cannot install Excel 2016 on the same PC as previous versions without causing unwanted problems I used a VM on my desktop and also ran the benchmark on my Surface Pro 3.
It is important to note that the least efficient methods involve those that use loops.
This is because they only delete one row at a time!
How can I find out which methods and properties are available for a particular object? You can also use the Object Browser available in the VBE.
Press F2 to access the Object Browser, then choose Excel from the Libraries/Workbooks drop-down list. When you select an object, its corresponding properties and methods appear in the list on the right.
You can either hide the unused rows and columns, or use a VBA statement to set the scroll area for the worksheet.
The statement below, for example, sets the scroll area on Sheet1 so the user cannot activate any cells outside of B2: D50.
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.
Looking at his benchmark and its VBA code you can see that has Screen Updating ON and repeatedly calculates in Automatic mode.
Each calculation triggers some RANDBETWEEN functions with a number of dependent cells.
Gurs has an interesting benchmark he has been running on various systems and Excel versions over the years.
His results seem to show a massive performance decline in later Excel versions.