Tommi,

One thing that can slow down code considerably is using Select
and Selection. With rare exception, it is never necessary to
Select an item or work with the Selection object. Instead of
code like

Range("A1").Select
Selection.Font.Bold = True

reference the range directly:

Range("A1").Font.Bold = True


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Tommi" wrote in message
...
Hello!
I have code, which manages lists (so the code will make heavy
use of
for-loops, comparisons, sorting, filtering and that kind of
stuff = quite
basic, but time-consuming).
Running my code will in some cases take quite a lot of time. In
the
beginning of every procedure, I put Application.ScreenUpdating
= False ( in
the end of procedure again True). I put also
Application.Calculation =
xlCalculationManual in the beginning (and in the end again to
Automatic).

Is there any other things, I should take into account, if I
want my code run
more efficiently?

BR, Tommi