Change Highlight color of active cell

  • Thread starter Thread starter M. Burnett
  • Start date Start date
M

M. Burnett

I would like to be able to change the color of the active
cell. In a large spreadsheet this would help in
distinguishing it from other cells without looking at
the "bolded" row and column.

Any ideas?
 
Try this: In the declaration (upper right corner), choose
activate:

Private Sub Worksheet_SelectionChange(ByVal Target As
Range)
If Not OldRng Is Nothing Then
OldRng.Interior.ColorIndex = xlNone
End If
Target.Interior.ColorIndex = 6
Set OldRng = Target
End Sub
 
Back
Top