Thread
:
Inability to calculate a range in Excel versions above 2000
View Single Post
#
2
Posted to microsoft.public.excel.programming
Charles Williams
external usenet poster
Posts: 968
Inability to calculate a range in Excel versions above 2000
Range Calculate does not support Iteration in any version: it just does not
complain about it in earlier versions.
So the correct solution is
Sub calc()
Dim mess
dim blIter as boolean
On Error GoTo er
blIter=application.iteration
if blIter then application.iteration=false
Selection.Calculate
if bliter<application.iteration then application.iteration=bliter
GoTo done
er:
mess = Error(Err)
MsgBox (mess)
done:
End Sub
Charles
______________________
Decision Models
FastExcel 2.1 now available
www.DecisionModels.com
"G Franc" <G
wrote in message
...
The macro below fails whenever the calculation tab in excel version 2002
and
newer are set to manual with interations checked. The MS EXCEL work around
is
to set calculations to automatic or to uncheck iterations. Neither option
is
suitable for my application.
Are others having a similar problem? My only solution to date is to
continue
running EXCEL 2000.
Sub calc()
Dim mess
On Error GoTo er
Selection.Calculate
GoTo done
er:
mess = Error(Err)
MsgBox (mess)
done:
End Sub
Reply With Quote
Charles Williams
View Public Profile
Find all posts by Charles Williams