Speeding Up A Spreadsheet

S

SamuelT

Hi all

I've got a large(ish) spreadsheet with a fairly voluminous amount o
formulas. Due to this it can take quite a while to open and run variou
macros that sift data depending on the user. This is fine with me, but
number of my colleagues are complaining that it takes too long to ge
into or sort (obviously never heard of patience being a virtue)

Aside from tinkering with the computer itself, can anyone suggest
means of speeding up the spreadsheet

TIA

Samuel
 
M

mrice

The simplest way is to turn the screen updating off. At the beginning of
your code put...


Application.screenupdating = False

They they might complain that they can't see anything happening. If
this is the case, true giving an occasional indication that something
is going on by setting the value of the status bar e.g.

Application.StatusBar = "Just started...."
...
...
...
...
Application.StatusBar = "Almost finished...."
...
End Sub
 
M

mrice

You might also try ridding your code of Select methods. If your macro
was recorded, it will be full of these.

For example..

Range("A1").Select
Selection.interior.colorIndex = 6

becomes

Range("A1").interior.colorIndex = 6
 
Top