You could do this: ' turn off updates ' Organise data in ram so that it fits the range for which it is meant Dim two_d_arr (rows,cols) load Data From Source two_d_arr Dim destination Range as Range destination Range = Sheets(some Sheet). number of cells updated), and how many sheets are there, how many sheets/cells refer to sheet your code is updating and how many formulas are present in the whole workbook. Screen Updating = False '-----------------------My code Application. Just make sure you reset Screen Updating to true when you're finished running the macro.Each time you change some thing in the sheet, Excel re-calculates all formulas. Thus, the main body of your macro can do its work behind the scenes without the necessity of stopping to update the screen.is your source for cost-effective Microsoft Excel training.This complete guide shows both professionals and novices how to master VBA in order to customize the entire Office suite for their needs. Tell the user what's going on and provide an indication of progress, ideally every three to ten seconds.
Third, there might be times when you are running code in sequence and you want to see what you did while you are doing it. Macros Two and Three are called by Macros One and Two, but you cannot see the results of your code until the last macro is completed, unless you had set the Screen Updating back to the way it was in each macro. Screen Updating = False Msg Box "Screen Updating is off now !! Value = "Two" Msg Box "Screen Updating is " & Application.
Do not believe these claims — they are misinformed and dead wrong.
Whenever you set Screen Updating to False in your code, make certain to reset it to True.
This tip (9151) applies to Microsoft Excel 2007, 2010, and 2013.
You can find a version of this tip for the older menu interface of Excel here: Turning Off Screen Updating.