title: How to remove shade from cell and leave interiour color as is
body: <p>I checked on the internet but could not find a solution. I the files we have mixed shaded and coloured cells, the shades need to be removed but the colours need to stay. I already have a range and want to fix it like below:</p>
  
  <pre><code>    Range(Cells(RowStart, ColStart), Cells(RowLast, ColLast)).Select
      With Selection.Interior
          .PatternTintAndShade = 0
      End With
  </code></pre>
  
  <p>It does not work when I use .Pattern = xlNone or .TintAndShade = 0 in both options I loose the cell interior color. Please advice</p>