Remove Interior Color in Column

[cart0250]

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

 

[Rick Rothstein]

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

Two possibilities come to mind, either...

1) Your cell colors are the result of Conditional Formatting

or...

2) Your last cell with any data in it is on a row prior to the first cell with any color in it.

Does either of these describe your current layout?