| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I get around the [Edit] [Calc] keystrokes for a formula?
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula not updating even after F9 calc | Excel Discussion (Misc queries) | |||
| calc. formula for % | Excel Worksheet Functions | |||
| Calc formula | New Users to Excel | |||
| auto calc on, but have to edit (f2) cells to force re-calc..help! | Excel Worksheet Functions | |||
| How do you use text in a formula so it will calc, but ignores txt | Excel Discussion (Misc queries) | |||
Linear Mode
