Quick sxce fat - Excel application screenupdating not working
It happens when there is transition among excel files.The same macro worked properly in win 7 with office 2010.
There is a word that you can use with Application that will neutralise all the alerts that Excel can send your way.
Discover this word and many others that you can use in combination with Application in the downloadable course on Excel macros. As you can read: starting in cell A1 a value of "99" will be entered in the selected cell then the cursor will move one cell down to enter "99", repeat the process until the row number of the selected cell is 3000 and come back to cell A1.
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.
Paste And Format (wd List Combine With Existing List) ' The above inserts a line which creates a second page, so delete a line after Selection. Delete Unit:=wd Character, Count:=1 Active Document. Close Save Changes:=wd Save Changes Next Set doc To Open = Nothing: Set Doc = Nothing ' Switch Screen updates back on Application.