Getting around [Edit][Calc] keystrokes to derive a value from a fo

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… 9700 iterations)

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

Gord Dibben

Either you have calculation set to manual or the data feeding the formulas is
perhaps text, not numeric.

Format all to General then copy an empty cell.

Select your numbers and Paste Special>Add>OK>Esc.

Sometimes this can work...........

Select the cells with formulas then Edit>Replace

What: =

With: =

Replace all.


Gord Dibben MS Excel MVP
 

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

How do I get around the [Edit] [Calc] keystrokes for a formula? 1
Macro to edit formula in cell 3
Calc Prorated Cost based on Specific Days in a Given Month & Year Range (Revisited..) 8
Code to change a named range 2
getting vlookup to return a formula instead of a value 1
Using a macro to edit a macro 1
Macro to convert dates in a Conditional Sum Formulas? 1
How to copy data from a "parent sheet" to another 19

Top