I want to start off this post by thanking everyone who sent in their examples in response to my January request.
It is incredibly helpful to be able to look at what you all are doing with Excel!
Then comment out the line which turns off screen updating and see what happens; you should find that you scroll down the sheet as the numbers get filled.
You can find a version of this tip for the ribbon interface of Word (Word 2007 and later) here: Turning Off Screen Updating.This means that the Word screen can look like it has "gone crazy" while the macro is running.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.You can verify that its working though by leaving it set to False. Option Explicit ' User Defined Error codes Const ERR_NO_WINDOW_HANDLE As Long = 1000 Const ERR_WINDOW_LOCK_FAIL As Long = 1001 Const ERR_VERSION_NOT_SUPPORTED As Long = 1002 ' API declarations for Find Window() & Lock Window Update() ' Use Find Window API to locate the Power Point handle.Private Declare Function Find Window Lib "user32" Alias "Find Window A" _ (By Val lp Class Name As String, _ By Val lp Window Name As Long) As Long ' Use Lock Window Update to prevent/enable window refresh Private Declare Function Lock Window Update Lib "user32" _ (By Val hwnd Lock As Long) As Long ' Use Update Window to force a refresh of the Power Point window Private Declare Function Update Window Lib "user32" (By Val h Wnd As Long) As Long Property Let Screen Updating(State As Boolean) Static h Wnd As Long Dim Version No As String ' Get Version Number If State = False Then Version No = Left(Application. Version, ".") - 1) 'Get handle to the main application window using Class Name Select Case Version No Case "8" ' For PPT97: h Wnd = Find Window("PP97Frame Class", 0&) Case "9" ' For PPT2K: h Wnd = Find Window("PP9Frame Class", 0&) Case "10" ' For XP: h Wnd = Find Window("PP10Frame Class", 0&) Case "11" ' For 2003: h Wnd = Find Window("PP11Frame Class", 0&) Case "12" ' For 2007: h Wnd = Find Window("PP12Frame Class", 0&) Case "14", "15" ' For 2010: h Wnd = Find Window("PPTFrame Class", 0&) Case Else Err.