Activesheet.Calculate failing to calculate
 

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

Activesheet.Calculate failing to calculate
 

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

Activesheet.Calculate failing to calculate
 

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