LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kevin Vaughn
 
Posts: n/a
Default Recalculation

Another possibility is a macro that changes calculation to manual before it
starts processing, and then, assuming that calculation had been automatic
before it started (which in your case would be an incorrect assumption)
changes calculation to automatic.

--
Kevin Vaughn


"workerboy" wrote:


Thanks for the help Andy. I guess i'll just make an auto open macro that
changes it to manual each time.


--
workerboy
------------------------------------------------------------------------
workerboy's Profile: http://www.excelforum.com/member.php...o&userid=34121
View this thread: http://www.excelforum.com/showthread...hreadid=542130


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Group & Outline and Recalculation BrianH Excel Discussion (Misc queries) 3 April 20th 06 09:19 AM
recalculation not working ynissel Excel Discussion (Misc queries) 0 March 9th 06 11:31 PM
Excel recalculation R Ormerod Excel Discussion (Misc queries) 3 May 4th 05 01:56 PM
Force Recalculation Ron_D Excel Discussion (Misc queries) 3 April 15th 05 08:17 PM
Need code to Autofit Row Height on recalculation Bob Tarburton Excel Discussion (Misc queries) 0 March 4th 05 08:31 PM


All times are GMT +1. The time now is 01:35 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"