How can I get Excel to calulate correctly in vba

G

Guest

Using Excel VBA I cannot get my spreadsheet to calculate properly. I am using
Worksheets("Calculation sheet").Calculate, calculate, I am finding and
replacing '=', and I am sending keys using SendKeys "%^{F9}", True.......but
a cell still does not calculate. Once I stop the code & hit F9 it then does
calculate! Does anyone have any advice please?
 

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

Excel 2007 SP1 - How to do F9 in VBA code? 3
Calculate message 1
Why does 'calculate' show in the status bar, even after i hit F9? 1
Formulas not calculating - Calculation is on Automatic & I pressed 2
How to convert , comma to . dot in excel to do the following calculation? 2
circular files; iterating to a "correct" solution 4
Excel 2003 worksheet doesn't auto calculate 4
auto calculate not working 1

Top