Menu
How can I Set all sheets fill color to No fill using VBA in excel (all cells). Same as select all sheets, Select all cells (Control+A) and change fill color to No fill.
429
The following line of VBA code will allow you to determine if a spreadsheet cell has a fill color. If the ColorIndex property of a given cell is equal to xlNone (-4142) then it can be determined that there is no fill color in that particular cell.
Default/no fill colour is grey.
Untested but should do the job:
Sub No_Fill_Wb()
Dim ws as worksheet
For each ws in Thisworkbook.Worksheets
ws.Cells.Interior.ColorIndex = 0
Next ws
End Sub
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
