How do I get around the [Edit] [Calc] keystrokes for a formula?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Check that calculation is set to automatic

Tools>Options>Calculation tab>Automatic

Biff
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Getting around [Edit][Calc] keystrokes to derive a value from a fo 1
Freeze Formulas - Replace Worksheet 5
lookup options 2
How to calc a column of formulas? 2
Leave a cell COMPLETELY blank if there is an error 6
multi variable calcs on multiple sheets... 4
Can you stop a formula from recalculating the second time 1
copying formulas 7

Back
Top