Application screenupdating excel
The DEL95HTMLempty Cells is designed to clean up the mess that Excel 95 creates when pasting from a web page into Excel.
My experience with pasting Excel 95 was that instead of continuing a row across it also frequently jumped down a row besides for what should have been on the same row.
It will automatically turn onwhen the macro is finished.
Sometimes you want to turn on the screen updating afteryou have turned it off, e.g.
Screenupdating = False' Turn on screenupdating:' (happens automaticly after a module is finished): Application.
Then when you open a book needing path updates you can click the button, to update the formulas on the current active book.
This is a simple example you can elaborate to loop through worksheets or get the files in the directory and open each file, update links for wholesale changes.
when you want to display a dialog or a message box tothe user.
The following sentence will turn on the screen updating: Application.
One of our accounting folks would like to change the name of a directory, which contains MANY MANY excel spreadsheets in various subdirectories. If the links are in formulas you can use code like this to run on each workbook.