VBA copy sheet from one workbook to another (values and format only)
<p>I have the following code to copy and paste one sheet from one wb to another:</p>

<pre><code> wb1.Worksheets("ws").Copy After:=wb2.Sheets(wb1.Sheets.Count)
</code></pre>

<p>I'm trying to only paste values and formatting, how would I go about doing this? </p>

<p>Also the process is taking a longer that expected time, possibly because the sheet I'm copying from contains a pivot table with a large amount of data. Is there anyway I can speed it up?</p>

<p>Thanks for the help!</p>