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.
This seems incredibly clumsy any ideas.Sub RemoveColoring() Dim NameCheck NameCheck = ActiveSheet.Name Sheets.Add Worksheets(NameCheck).Select End Sub
Thanks
Peter
Bookmarks