Excel crashing due to loop

[MarkCBB]

HI there,

I am running some code that very basically copies and moves a sheet from a workbook and saves it, every loop creates an invoice, currently it loops 170 times but excel cant seem to make it past 170 all the time. is there any reason why this happens?

 

[MarkCBB]

o yaar, sorry blond moment. been awake for sometime now. will update you after I run the new code, thanks for the idea.

 

[MarkCBB]

turns out the code that I wass using to paste values before the copy and move sheet, was the challanges, i changed the code to paste the values on the new sheet, then save it. works perfectly now. I dont understand why, but it works better.