Repeat F2
 

As my spreadsheet is heavily laced with formulas it takes about 20 minutes or
so for the whole spreadsheet to finish calculating if I use the F9 key. So
to speed things up I would like to have Excel refresh 4,000 (or so) records
using the F2 <enter keystrokes. Is there a way to have Excel do this through
Vba?

Repeat F2
 

select the cells and do an edit=Replace and replace the equal sign with an
equal sign.

Or, you can do something like

Range("A1:A4000").Calculate

--
Regards,
Tom Ogilvy

"briank" wrote in message
...
As my spreadsheet is heavily laced with formulas it takes about 20 minutes
or
so for the whole spreadsheet to finish calculating if I use the F9 key.
So
to speed things up I would like to have Excel refresh 4,000 (or so)
records
using the F2 <enter keystrokes. Is there a way to have Excel do this
through
Vba?

Repeat F2
 

Perfect, I knew that had to be a better shortcut!

"Tom Ogilvy" wrote:

select the cells and do an edit=Replace and replace the equal sign with an
equal sign.

Or, you can do something like

Range("A1:A4000").Calculate

--
Regards,
Tom Ogilvy

"briank" wrote in message
...
As my spreadsheet is heavily laced with formulas it takes about 20 minutes
or
so for the whole spreadsheet to finish calculating if I use the F9 key.
So
to speed things up I would like to have Excel refresh 4,000 (or so)
records
using the F2 <enter keystrokes. Is there a way to have Excel do this
through
Vba?