uktous
10-13-2012, 09:52 AM
Hi,
How can I highlight the last selected cell?
It is easy to highlight the current selected cell, but I don’t know how to highlight the last selected cell.
Macro for highlighting the current selected cell:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Selection.Interior.Color = 65535
End Sub
Thanks
How can I highlight the last selected cell?
It is easy to highlight the current selected cell, but I don’t know how to highlight the last selected cell.
Macro for highlighting the current selected cell:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Selection.Interior.Color = 65535
End Sub
Thanks