Calculation Enable

R

raj08536

Active Member
Joined
Aug 16, 2007
Messages
322
Office Version
  1. 365
Platform
  1. Windows
Following is the wrong syntex

Worksheets("HighlevelFcstSite").Range("A253:IV2000").EnableCalculation = False

Can a Guru help me to correct this one?
 

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.
Sort by date Sort by votes
MrKowz

MrKowz

Well-known Member
Joined
Jun 30, 2008
Messages
6,653
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
You can't disable calculations for a specific range, but you can for the entire application:

Code: 
Application.Calculation = xlCalculationManual
 
Upvote 0
R

raj08536

Active Member
Joined
Aug 16, 2007
Messages
322
Office Version
  1. 365
Platform
  1. Windows
Thanks for your prompt response.

However, following is working perfectly fine at worksheet level but range level is not working.


Worksheets("HighlevelFcstSite").EnableCalculation = True
 
Upvote 0
shg

shg

MrExcel MVP
Joined
May 7, 2008
Messages
21,836
Office Version
  1. 2010
Platform
  1. Windows
Or a whole worksheet:

Worksheets("HighlevelFcstSite").<S>Range("A253:IV2000").</S>EnableCalculation = False

EDIT: See Applies To in Help for the EnableCalculation property.
 
Last edited:
Upvote 0
You must log in or register to reply here.

Similar threads

A
  • Solved
Automatic Calculation
2 3
Replies
20
Views
652
Anthony47
A
A
  • Solved
VBA to Turn on or off auto calculate
Replies
6
Views
777
APML
A
H
  • Solved
Enabling a Button based on multiple Changes to Userform
2
Replies
16
Views
245
Hitman51
H
A
  • Solved
If-then Calculation Across Rows/Columns Based On Other Columns.
Replies
8
Views
449
RobP
R
N
  • Question
Macro help!
Replies
5
Views
124
HaHoBe
HaHoBe

Forum statistics

Threads
1,191,348
Messages
5,986,142
Members
440,005
Latest member
tombamber

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
Top