bwait
05-06-2019, 03:31 PM
Hi,
In the snippet below, how can I skip 3 header rows and start the Range on B4:D4?
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Cells.Count > 1 Then Exit Sub
If Target.Column >= 1 And Target.Column <= 5 Then
If Not Intersect(Target, Range("B" & Target.Row & ":D" & Target.Row)) Is Nothing Then
...
In the snippet below, how can I skip 3 header rows and start the Range on B4:D4?
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Cells.Count > 1 Then Exit Sub
If Target.Column >= 1 And Target.Column <= 5 Then
If Not Intersect(Target, Range("B" & Target.Row & ":D" & Target.Row)) Is Nothing Then
...