Excel Ranges
Thanks guys.
I used this from Bob... nice one!
Private Sub Worksheet_SelectionChange(ByVal Target As
Range)
Dim rng As Range
With Target
Application.EnableEvents = False
Set rng = Union(.EntireRow, .EntireColumn)
rng.Select
.Activate
Application.EnableEvents = True
End With
End Sub
|