View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Active Cell Fill Colour

No reason for the Target.Select on the end. The selection hasn't changed.

Just note that this will clear any range you may have copied from the
clipboard effectively disabling pasting to this page.

--
Regards,
Tom Ogilvy

"Carim" wrote in message
oups.com...
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