Set all sheets' fill color to "No Fill" using VBA in excel
I used "0" in my code (see below) working with Excel 2016 and it turned my columns black.
Master.Columns(Col_Start).Interior.Color = 0
Using "xlNone" per below, however, did work for me.
Master.Columns(Col_Start).Interior.Color = xlNone
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