uktous
10-19-2012, 08:21 AM
Hi,
I created a macro that can highlight the selected cell.
However, my macro will clear the colour in all cell before it highlights the selected cell.
Is it possible to amend it so that it will clear the colour in the previous selected cell only, rather than clearing colour in all cells?
I want the macro that has this feature:
Clear the colour in previous selected cell only, then highlight the current selected cell.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Set x = Selection
Cells.Interior.ColorIndex = xlNone
x.Interior.Color = 65535
End Sub
Thanks
I created a macro that can highlight the selected cell.
However, my macro will clear the colour in all cell before it highlights the selected cell.
Is it possible to amend it so that it will clear the colour in the previous selected cell only, rather than clearing colour in all cells?
I want the macro that has this feature:
Clear the colour in previous selected cell only, then highlight the current selected cell.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Set x = Selection
Cells.Interior.ColorIndex = xlNone
x.Interior.Color = 65535
End Sub
Thanks