cycle through records on one sheet and write 6 rows per record on another sheet

It might be that the slowness is caused by your formulae recalculating.

If so you might try

Please Login or Register  to view this content.

towards the start of the code and

Please Login or Register  to view this content.

at the end

thank you very much, right now it's taking about 2 minutes so your suggestion worked very well, however 2 minutes is still too long. i've been told that we might have thousands of records on sheet1 so it will take too long, can i use an array or something like that to "paste" all the cells at once?

EDIT: i think i've figured it out, i just assign the values (which is very fast) and then add the formulas and such