If you're going to work with another application, such as Word, declare your OLE object directly, rather than as an Object type variable.By doing so, a great deal of overhead is done at compile time ("Early Binding") rather than at run time ("Late Binding").

One thing you may want to do with your macro to make it run faster and to prevent distracting flashes on the screen is to turn off screen updating while the macro is running.Normally, Excel will recalculate a cell or a range of cells when that cell's or range's precedents have changed.This may cause your workbook to recalculate too often, which will slow down performance.By setting Screen Updating to False at the Start of the macro, you will not only stop the constant screen flickering associated with recorded macro, but also greatly speed up the execution of the macro.The reason it speeds up code is because Excel no longer needs to repaint the screen whenever it encounters such commands as Select, Activate, Large Scroll, Small Scroll and many others. Screen Updating=False should be placed at the Start of your macro like shown below Note how we have set the Screen Updating back to True on completion.