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!

How do I make a cell transparent in Excel?

If you've set cell colors, however, you need to remove them to see the graphic. Select any colored cells and click the arrow by the "Fill Color" icon in the Home tab. Pick "No Fill" to make the cells transparent.

How do you clear a cell in VBA?

Code: Range (“A1:C3”).Delete It will delete the mentioned cell values, just like our clear method. You can use the VBA CELLS property. In VBA concepts, cells are also the same, no different from normal excel cells.

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