So does that mean that anything in A100 will be overwritten? maybe i should choose something out of the used range like 50000 as the largest sheet has 46,000 rows used.

Regards,
Simon