As you know Excel has got 1048574 rows. How can I export more than one million rows below my code ? if max rows is reached then how can I continue over new worksheet in Loop ? how to adapted it? I'm googling some after I find nice As you know Excel has got 1048574 rows. How can