title: In Excel VBA, why removing duplicate entries in a range removes the cell background color?
body: <p>My Worksheet has Grey Color for all cells. I'm selecting a range in a column and removing the duplicates.  It removes the duplicates as intended but it also makes the duplicate cell's color to its default white. I tried multiple examples but looks like they were done with default white color and likely this issue would have never occurred. I can programatically set the color back to its original but I don't want to do so before knowing why it is happening this way. Following is my Code</p>
  
  <pre><code>LastRow = GetLastRow(SheetName, ConsolidatedColumn) 'ConsolidatedColumn is "P"
  WS.Range(ConsolidatedColumn &amp; "1:" &amp; ConsolidatedColumn &amp; LastRow) _
      .RemoveDuplicates Columns:=Array(1), Header:=xlYes
  </code></pre>
  
  <p>Can someone explain why this happening?.</p>