title: xlPasteValues and xlPasteFormats at the same time
body: <p>I am copying a range and then pasting it's values and formats to another range:</p>
  <pre class="lang-vb prettyprint-override"><code>ws5.Range(&quot;F3:N&quot; &amp; xCell).SpecialCells(xlCellTypeVisible).Copy
      
  ws16.Cells(Rows.Count, &quot;B&quot;).End(xlUp).Offset(4, 0).PasteSpecial xlPasteValues
  ws16.Cells(Rows.Count, &quot;B&quot;).End(xlUp).Offset(4, 0).PasteSpecial xlPasteFormats
  </code></pre>
  <p>Is it possible to do these two paste actions in one action without using <code>With</code>?</p>
  <p>I would like to increase the speed of my macro and that kind of small reduction might help me.</p>
  <p>Is there something like <code>.PasteSpecial xlPasteValues and xlPasteFormats</code>?</p>
  <p>I found <a href="https://www.mrexcel.com/forum/excel-questions/167518-pastespecial-values-formats-same-time.html" rel="nofollow noreferrer">link</a> but even this answer is using <code>With</code>, which is useless for me.</p>