title: Copy sheet without flicker
body: <p>I would like to copy a template sheet to the left of itself to be populated by a report generator.  This all works fine.</p>
  
  <p>However when it comes to the sheet copying line (shown below) their is a flash as excel appears and then disappears - though occasionally I am left with a blue, partially filled in excel window.</p>
  
  <p>I already have <code>Application.ScreenUpdating</code> set to false and <code>.Visible</code> is also set to false, and I reset them everytime to minimise the disruption. This flash is really annoying. Is there anyway of preventing it?</p>
  
  <pre><code>        ' create new sheet from template sheet
          shtDeliveryVariance.Copy Before:=shtDeliveryVariance
          Set shtVariance = Sheets(shtDeliveryVariance.Index - 1)
          shtVariance.Name = "Delivery Variance " &amp; Format(nSheetNumber, "000")
  
          ' minimise the flashes
          Application.Interactive = False
          Application.ScreenUpdating = False
          Application.Visible = False
  </code></pre>
  
  <p><strong>Update</strong>: If I use <code>Set shtVariance = Sheets.Add</code> I don't get the flash, but I lose all the pretty formatting.</p>