title: How to use VBA to make a cell in Excel 2007 transparent
body: <p>I currently have:</p>
  
  <pre><code>Range("Z1").Interior.Color = RGB(255, 255, 255)
  </code></pre>
  
  <p>But this wipes out the borders of the cells.  Instead I'd just like to set the transparency of the cells in range to 1.0.  <a href="http://msdn.microsoft.com/en-us/library/bb242318%28v=office.12%29.aspx" rel="nofollow noreferrer">The docs</a> seem to suggest it doesn't exist (?).</p>
  
  <p>Thanks!</p>