Posted to microsoft.public.excel.programming

Volker Hetzer Volker Hetzer is offline

external usenet poster

Posts: 5

Stopping formula computations during entering data...

Norman Jones wrote:
Hi Volker,

Try:

Application.Calculation = xlCalculationManual

'Your code

Application.Calculation = xlCalculationAutomatic
Thanks a lot, both of you!
Volker

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
computations at odd locations	Utkarsh	Excel Discussion (Misc queries)	2	January 21st 10 06:41 PM
Stopping IF command from entering zero or 1 for blank cells	Nick S	Excel Worksheet Functions	3	November 20th 09 05:41 PM
Stopping a formula	Roachy	Excel Discussion (Misc queries)	3	July 1st 08 03:31 PM
DATE COMPUTATIONS	sonarmark	Excel Worksheet Functions	2	April 9th 08 03:29 PM
manually entering data in a cell with formula w/o losing the formu	MelB	Excel Discussion (Misc queries)	2	October 7th 07 02:14 PM

All times are GMT +1. The time now is 02:39 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us