Application screenupdating true
The first time the example hides the columns, screen updating is turned on; the second time, screen updating is turned off. Hidden = True End If Next c stop Time = Time elapsed Time(i) = (stop Time - start Time) * 24 * 60 * 60 Next i Application.
When you run this example, you can compare the respective running times, which are displayed in the message box. Screen Updating = True For i = 1 To 2 If i = 2 Then Application.
He is president of Sharon Parq Associates, a computer and publishing services company. Check out Hi, I am unable to work on excel while it pulls the external web data ( refresh every 1 minute ).... Tell the user what's going on and provide an indication of progress, ideally every three to ten seconds.
My requirement is to work on another worksheet of the same workbook... I've written several macro programs that take a while to execute. For example, one program I alone use takes about 40 seconds to execute across 12 similar sheets.
For long macros I would advocate displaying a Userform saying "Please Wait" and for very long macros showing a progress bar or percentage complete, and maybe even a "Cancel" button to exit before completion.Many times the macro may do quite a bit with the data, such as selecting different cells, replacing values or formulas, and taking other types of actions.