Forum Discussion
Solved
Speed of assigning values to cells?
Newbie here. I have a macro which gathers data from a variety of places and then builds a summary table. The calculations are extremely fast. That is, if I don't DO anything with the counts, th...
Hi,
turn screenupdating to false at the beginning.
Sub Macro()
Application.screenupdating = false
Application.Calculation = xlCalculationManual
'Your code
Application.Calculation = xlCalculationAutomatic
Application.Screenupdating=true
End SubBest regards
Bernd
http://www.vba-tanker.com
Hi,
turn screenupdating to false at the beginning.
Sub Macro()
Application.screenupdating = false
Application.Calculation = xlCalculationManual
'Your code
Application.Calculation = xlCalculationAutomatic
Application.Screenupdating=true
End Sub
Best regards
Bernd
http://www.vba-tanker.com
Berndvbatanker That makes a huge difference :-) Thanks!
