Write range ...step

If possible, you can try to use Append Range. If you still want to use Excel, checkout the below link: