Wierd calculation error (2003 sp2)

bill

Well-known Member
Joined
Mar 7, 2002
Messages
550
hey there.

This code:
Sub testing123()
Me.Range("OK").Calculate
End Sub

generates a CALCULATION METHOD OF RANGE CLASS FAILED error.

----------------------- Setting it up -----------------------

1) Open a new workbook.
2) Create a local RANGED NAME on SHEET1 against a handful of cells (your call!) - name it sheet1!OK
3) Within the range, set one cell formula to: = 0/0
4) set CALCULATION to MANUAL
5) run the code.

My VBA skills may be rusty but I don't ever recall this situation throwing an error.

thx!
 
Last edited:

Some videos you may like

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
36,151
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
I can't replicate that error. How are you calling the code - from the VBE?
 

bill

Well-known Member
Joined
Mar 7, 2002
Messages
550
All is within the Excel/VBA environment where the code is dropped into the Sheet1 class.

And yes, after entering into the VBE, stepping though the code throws the error.

On my end, need to make sure CALCULATIONS are set to MANUAL... On my end, did this from the GUI (TOOLS>OPTIONS>CALCULATION=MANUAL).

I'm am assuming our infrastructure group rolled out a service pack that is causing the error but need to make sure I didn't forget 'the rules' before I blame the heck out of them :)

And yse, tried on another users machine within the org and they too have the same issue (in fact, tried on 3 machines).
 

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
36,151
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
Well, it works fine for me using Excel 2003 11.8146.8132 (SP2) following your instructions.
 

bill

Well-known Member
Joined
Mar 7, 2002
Messages
550

ADVERTISEMENT

my version is: 11.6560.6568 SP2 and thank you for trying it!
 

Jonmo1

MrExcel MVP
Joined
Oct 12, 2006
Messages
44,061
Well, I can't replicate either. There's got to be more involved in the problem. I assume you're "dumming down" the problem, otherwise I have to ask Why you have a formula =0/0 ? That just makes no sense..
 

bill

Well-known Member
Joined
Mar 7, 2002
Messages
550
yeah, a very annoying issue... I recreate the problem on my end and somtimes it IS a problem and sometimes not.

yes, simplified the issue for post on the board.
 

Watch MrExcel Video

Forum statistics

Threads
1,123,259
Messages
5,600,575
Members
414,390
Latest member
plimbu

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