View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Daniel Bonallack Daniel Bonallack is offline
external usenet poster
 
Posts: 110
Default 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