Remove BackGround Color

[mitchbvi]

I am using Excel 2011 on a Mac and have a number of routines that call tasks like autofit. Some the whole worksheet or a range of columns. My problem is that on completion the all the columns or those specified remain highlighted in blue. The only way I have found of getting rid of that is to run this.

Please Login or Register  to view this content.

This seems incredibly clumsy any ideas.

Thanks

Peter

[mitchbvi]

Sorry to bother anyone this is the solution

Cells.Interior.ColorIndex = xlNone 'This removes any highlighting