Posted to microsoft.public.excel.programming

Gareth[_3_] Gareth[_3_] is offline

external usenet poster

Posts: 109

Application.Calculation

A file contains too many formula and the Status Bar doesn't work (display
number of rows when AutoFilter is used).

Is it possible to switch caculation to manual when AutoFilter is on and back
to automatic when AutoFilter is switched off?

Thanks in advance.

Gareth

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
Application.Calculation Problems	Jive	Excel Worksheet Functions	2	February 7th 08 02:21 PM
Application Calculation Error	Rick B[_4_]	Excel Programming	2	December 2nd 03 08:49 PM
Application.Calculation=xlCalculationManual causing run time error?	Dave Peterson[_3_]	Excel Programming	3	October 18th 03 12:51 AM
range.calculation with UDF not working when calculation is set to automatic	Brian Murphy	Excel Programming	5	October 14th 03 07:02 PM
Application.Calculation exception	Bill Lunney	Excel Programming	0	July 29th 03 04:46 PM

All times are GMT +1. The time now is 05:07 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us