title: Changing Cell color
body: <p>I want to change the color in a Cell</p>
  
  <pre><code>MyColour = Range("A" &amp; myRow).Cells.Interior.Color  ' &lt;&lt;&lt; THIS line doesn't work !
  
  Range("A" &amp; myRow).Cells.Interior.Color = Range("A" &amp; myRow-3).Cells.Interior.Color
  </code></pre>
  
  <p>and then later change it back again.</p>
  
  <pre><code>Range("A" &amp; myRow).Cells.Interior.Color = MyColour
  </code></pre>