View Single Post
  #6 (permalink)  
Old December 19th, 2005, 12:45 PM
mjppaba mjppaba is offline
Friend of Wrox
 
Join Date: Jan 2005
Location: Bournemouth, Dorset, United Kingdom.
Posts: 180
Thanks: 0
Thanked 0 Times in 0 Posts
Default

1. Do you use loops in your code. If so it may be quicker to sort the data using the 3 primary key fields, then conduct a find rather than loop.

2. Do you have lots of calculations/ functions and formula in the workbooks. e.g. Row 1 to 10000 may need the formulae to begin with, but once calculated make a copy of the recordset and paste the formula as values on all but the first line, any subsequent recalculation is only required on line 1. This is a big time saver.

3. Upgrade your PC with more memory

4. reduce the number of lookups in the formula, if you can use arrays to hold data in memory.


cheers

Matt

Reply With Quote