Seeing the code will help.

Maybe what can speed this up is putting the data in an array, examine that
array, write to a second array and at the end write that second array back
to a sheet.

RBS

"asyado" wrote in message
...
Hi,

Can anyone shed any light on the problem i'm having with following macro.
I have 15k lines of data on a worksheet. My program examines each line
with
an if statement and depending on result inserts 3 new lines, adds 15 cells
of
data for each line, or else moves to the next line.
I have screenupdating set to false, xlcalculation set to xlAutomatic.

This is the part i find curious - if i limit the number of lines of data
to
<8,000 then the program runs in about 7-8 secs. If i try to run the
program
with the full 15, lines it takes up to 18 mins to run.

Sorry if i've not provided all pertinant info, lemme know if i need to add
something else.
TIA.



--
John