Hello, I'm trying to remove interior color for all cells in a column beginning with row 2 thru the last row containing data.
I'm using code as below but for some reason, it is not removing the color. No error message.
Can anyone see what I'm missing here?
Range("A2:A" & Cells(Rows.Count, "A").End(xlUp).Row).Interior.ColorIndex = xlNone
I'm using code as below but for some reason, it is not removing the color. No error message.
Can anyone see what I'm missing here?
Range("A2:A" & Cells(Rows.Count, "A").End(xlUp).Row).Interior.ColorIndex = xlNone
Last edited: