Problem with removing color from cell

[UnsolvedCoding]

I can't figure out why the color won't get removed from a cell. I have tried many variations of what is below both with color and color index.

Sheets("Info").Range("AL" & B - 9 & ":AP" & B - 9).Interior.ColorIndex = -4142

Sheets("Info").Range("AL" & B - 9 & ":AP" & B - 9).Interior.ColorIndex = 0

Sheets("Info").Range("AL" & B - 9 & ":AP" & B - 9).Interior.ColorIndex = xlnone

Sheets("Info").Range("AL" & B - 9 & ":AP" & B - 9).Interior.ColorIndex = xlcolorindexnone

Coloring the cells hasn't been a problem. Both of these are accepted without question.
Sheets("Info").Range("AG" & C + 1 & ":AI" & C + 1).Interior.ColorIndex = 36
Sheets("Info").Range("AG" & C + 1 & ":AI" & C + 1).Interior.Color = 10092543

 

[SkipVought]

Hi,

Personally, I'd be trying to solve this problem on the sheet. THEN, having found a solution, apply the code if this problem tends to be recurring.

Do you have any Conditional Formatting in this range?

Skip,

_{Just traded in my OLD subtlety...
for a NUance!}

 

[UnsolvedCoding]

No conditional formatting.

I have tried the macro recorder but get the same problem.

One thing I just realized I haven't done is use a with statement. I will give that a shot.

 

[SkipVought]

Can you upload your workbook?

Skip,

_{Just traded in my OLD subtlety...
for a NUance!}

 

[UnsolvedCoding]

Not without company permission.

 

[UnsolvedCoding]

I can tell you that the excel sheet is used to make panel layouts for communication and power distribution.

 

[SkipVought]

Can't you MANUALLY Select ALL cells and change the Interior to No Fill?

Skip,

_{Just traded in my OLD subtlety...
for a NUance!}

 

[UnsolvedCoding]

Got it. Instead of subtracting from the value of B I changed the value of B to compensate and it runs.

Thanks Skip.

 

[SkipVought]

Are you running a loop?

Just reference the entire range: ONE STATEMENT.

Skip,

_{Just traded in my OLD subtlety...
for a NUance!}