<div>
<div class="content wysiwyg-content">
The code below coppies certain range.<br />
<br />
wsModel.Range(&quot;A1:Z500&quot;).C<wbr />opy Destination:=ws.Range(&quot;A1:<wbr />Z500&quot;)<br />
<br />
Question: How can I change it to copy the entire Sheet1 (from wsModel to/over ws)?<br />
<br />
Note: Both wsModel and ws have Sheet1 on them.<br />
<br />
Thank you.
</div>
</div>


The code below coppies certain range.

wsModel.Range("A1:Z500").Copy Destination:=ws.Range("A1:Z500")

Question: How can I change it to copy the entire Sheet1 (from wsModel to/over ws)?

Note: Both wsModel and ws have Sheet1 on them.

Thank you.

In Access, copy Sheet1 from Source.xls over Sheet1 in Target.xls

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.