code to turn off autocalc before a macro starts

J

jts2004

Board Regular
Joined
Apr 21, 2004
Messages
156
need code to turn off auto calc before a macro starts then turn it back on at the end. Have a formula intense sheet and the macro is slow waiting for cells to calc
 

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.
Sort by date Sort by votes
Code: 
Application.Calculation = xlCalculationManual

code

Application.Calculation = xlCalculationAutomatic

P.S.
don't forget the Macro Recorder. You can answer many of your own questions with that.
 
Upvote 0
You must log in or register to reply here.

Similar threads

J
  • Question
VBA not turning off autosave function for some people
Replies
5
Views
153
Joe4
Joe4
rjplante
  • Question
VBA to turn off save functions
Replies
2
Views
165
Fluff
Fluff
P
  • Question
Grouping of sheets and enabling/disabling Autocalcs
Replies
1
Views
199
OaklandJim
O
S
  • Solved
Macro to reset filters in all tables in entire workbook
Replies
1
Views
242
sspatriots
S
M
  • Question
IF Vlookup formula locking up file
2
Replies
10
Views
132
Joe4
Joe4

Forum statistics

Threads
1,214,393
Messages
6,119,261
Members
448,880
Latest member
aveternik

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top