title: Eliminate the Remove Duplicate msg in vba
body: <p>This has me stumped. In my vba code I am removing duplicates in a column using </p>
  
  <pre><code>Columns("AB:AB").Select
      Range("AB5").Activate
      Application.CutCopyMode = False
      Selection.Copy
      Sheets("SFDC_Data").Select
      Columns("E:E").Select
      Range("E5").Activate
      Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:=_
          False, Transpose:=False
      Range("E2").Select
      Application.CutCopyMode = False
      Columns("E:E").Select
      Range("E5").Activate
      ActiveSheet.Range("E:E").RemoveDuplicates Columns:=Array(1), Header:=xlYes
  </code></pre>
  
  <p>The popup comes up making me confirm before it will perform the duplicate removal.  How can I get rid of that popup or automatically confirm it?</p>
  
  <p>Any help?! I have tried all kinds of things including, </p>
  
  <pre><code>Application.DisplayAlerts = False
  Application.EnableEvents = False
  Application.ScreenUpdating = False
  </code></pre>
  
  <p>Please Help!</p>