Activesheet.Calculate failing to calculate

[Guest]

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

 

[Guest]

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

 

[Guest]

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