I've been using the code below on several spreadsheets and find it very helpful. However as I'm sure you know it will remove any fill colours from a cell. This is really a particular issue with a spreadsheet I am now using and was wondering if there was either:
1) A way to do something similar without affecting the fill colours
Or
2) Limiting this code to say rows 11 and below?
Thanks
Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
Cells.Interior.ColorIndex = xlColorIndexNone
Target.EntireRow.Interior.ColorIndex = 44
End Sub
Bookmarks