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!
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: