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:

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.
I can't replicate that error. How are you calling the code - from the VBE?
 
Upvote 0
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).
 
Upvote 0
Well, it works fine for me using Excel 2003 11.8146.8132 (SP2) following your instructions.
 
Upvote 0
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..
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,213,535
Messages
6,114,198
Members
448,554
Latest member
Gleisner2

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