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
|