Posted to microsoft.public.excel.programming

Michael Singmin Michael Singmin is offline

external usenet poster

Posts: 60

VBA Calc

Hello Group,

What is the equivalent of Calc (F9) in VBA ?

My application has a lot of complex array entered formulas
so I keep the calculation set as manual.

When new data values are entered and the database sorted,
I would like to do a recalculation so the array formaulas can be
updated.

Thanks,

Michael Singmin

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Calc = Manual & Do Not Calc b/4 SAVE	Ken	Excel Discussion (Misc queries)	0	October 3rd 07 02:28 PM
Calc	DStore	Excel Worksheet Functions	2	September 21st 07 06:22 PM
My calc key on Excel changes box to "Text" Box and doesn't calc ?	jack	Charts and Charting in Excel	0	August 8th 06 07:30 PM
auto calc on, but have to edit (f2) cells to force re-calc..help!	Curt	Excel Worksheet Functions	3	February 13th 06 06:05 PM
Re-Calc	Jerry[_16_]	Excel Programming	3	January 15th 04 11:08 PM

All times are GMT +1. The time now is 08:15 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us