View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Claude Claude is offline
external usenet poster
 
Posts: 36
Default Forced recalculation in Excel

Hi all

I find that Excel does not always calculate properly when
pressing F9. I have been shown the trick with Ctrl-Alt-F9,
which forces a recalculation of all formulas in all open
files and sheets. Is there an equivalent to this in VBA?