Remove Cell Color after Code is Deleted

[fixedpower]

Hello: I added some code on an Excel tab to highlight the active
row. It worked fine, but I decided that I did not want this feature
on my project...so I deleted the code.

My problem is that the last row highlighted by the code remains
highlighed and I cannot seem to change the fill back to normal.

Any suggestions? What is controlling the color at this point since
the code has been removed?

Thanks!

 

[fixedpower]

Anyone have a suggestion? It is strange because I cannot change the
highlighting back to normal (no fill or white) with the format cell
commands.

Thanks!

 

[Gord Dibben]

Can you change fill color on all other rows/cells?

Post the code you used to color the active row/cell.

Although I would think that should not prevent making changes, but who knows
what evil lurks in the shadows.

Especially with Excel and its idiosyncratic behaviour at times.


Gord Dibben MS Excel MVP

 

[Zack S.]

Hi,
I wanted to follow up on this. After I deleted the code, the
highlighting remained via conditional formatting on every cell, for
the entire row. My workaround was to delete the subject row (which I
wanted to avoid). The code contained language that highlighted a row
only if it contained data...hence the conditional formatting. Thanks
for the suggestion, Gord.

 

[Gord Dibben]

Might have been easier to clear the CF for that row instead of deleting the
entire row.

Gord