View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Carim[_3_] Carim[_3_] is offline
external usenet poster
 
Posts: 137
Default Active Cell Fill Colour

Hi uplink600,

Here is the code I am using :

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Cells.Interior.ColorIndex = xlNone
Target.Interior.ColorIndex = 6
Target.Select
End Sub

HTH
Cheers
Carim