At some stage during my macro, I have the line "Activesheet.Calculate"

Unfortunately, it fails to calculate anything. Returning to Excel, Shift+F9
doesn't work either.

I've played around with Activesheet.EnableCalculation, without success.

F9 does recalculate the page, but I don't want to use this when I only want
one sheet calculated.

Thanks in advance

Daniel

Is the correct sheet "Active". Maybe you need to activate the sheet you want
first.
--
JNW


"Daniel Bonallack" wrote:

> At some stage during my macro, I have the line "Activesheet.Calculate"
>
> Unfortunately, it fails to calculate anything. Returning to Excel, Shift+F9
> doesn't work either.
>
> I've played around with Activesheet.EnableCalculation, without success.
>
> F9 does recalculate the page, but I don't want to use this when I only want
> one sheet calculated.
>
> Thanks in advance
>
> Daniel
>

Hi, yes, life would be simple if the answer were that easy...


"JNW" wrote:

> Is the correct sheet "Active". Maybe you need to activate the sheet you want
> first.
> --
> JNW
>
>
> "Daniel Bonallack" wrote:
>
> > At some stage during my macro, I have the line "Activesheet.Calculate"
> >
> > Unfortunately, it fails to calculate anything. Returning to Excel, Shift+F9
> > doesn't work either.
> >
> > I've played around with Activesheet.EnableCalculation, without success.
> >
> > F9 does recalculate the page, but I don't want to use this when I only want
> > one sheet calculated.
> >
> > Thanks in advance
> >
> > Daniel
> >