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