Thread: How do I get around the [Edit] [Calc] keystrokes for a formula?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
  
Posts: 15,768
Default How do I get around the [Edit] [Calc] keystrokes for a formula?
Check that calculation is set to automatic

ToolsOptionsCalculation tabAutomatic

Biff

"fpa_177" wrote in message
...
My dilemma is that in creating a formula, I have to [Edit] & [Calc] each
cell
containing the formula in the array in order for the formula to work (9700
cells)

Is there a function I can use to perform the [Edit] [Calc] functionality,
bypassing the actual keystrokes?... maybe Macro language?



Reply With QuoteReply With Quote