Tim,

I'll get to work on this. Mail you when I'm done.

The main speed increase will probably come from disabling recalculation,
screenupdating etc..

I'll also rewrite it bit to put the loops in a loop instead of
repeating same code 6 times.


keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"_______Tim_______" wrote:

Hi,

I am using this macro to run numbers through a calculator
in another sheet. It takes numbers from the same columns
except for one column, row to row and deposits the results
in another column. Basically it is the same sub routine
duplicated to shift to the variable column 10 times. This
macro takes 4 hours to run 10 columns of new data through
5,000 - 10,000 rows of data depending on the size of the
sheet. Is there a way to write this macro so it finishes
faster? If you need more information, let me know.

Regards, Tim