Screenupdating not working
Since my computer was upgraded to win 10 with office 2016, Application.screenupdating=false command in VB (excel) doesn't work properly.
The screen flickers and the excel macro runs slowly.
Simply add the following code line to achieve this.
This tells Excel that the file has been saved already - even if it hasn't.
You may also want to read: Excel VBA custom Function last row and last column Excel delete blank rows and blank cells before import into Access Excel VBA Used Range is a worksheet Property, it returns the area Range bounded by first used cell and last used cell.