Menu
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!
596
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.
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
92
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
