Search code examples
excelvbaexcel-2007transparencycell

How to use VBA to make a cell in Excel 2007 transparent

I currently have:

Range("Z1").Interior.Color = RGB(255, 255, 255)

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. The docs seem to suggest it doesn't exist (?).

Thanks!

Solution

  • Range("Z1").Interior.ColorIndex = xlNone