Remove Interior Color in Column

cart0250

Active Member
Joined
Jun 24, 2006
Messages
285
Office Version
  1. 2016
Platform
  1. Windows
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
 
Last edited:

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney
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?
 
Upvote 0

Forum statistics

Threads
1,223,897
Messages
6,175,270
Members
452,628
Latest member
dd2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top