Little bit of a timewarp but if someone else wanders to this post there are additional parameters that can be input to the 'CopyFromRecordset' method.
The first one is unknown, the others are described below:
outputrange.CopyFromRecordset rs, {max rows}, {max columns}
i.e...