PDA

View Full Version : Skip heading rows with Range Offset



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
...

大灰狼1976
05-06-2019, 09:42 PM
Hi bwait!

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Cells.Count > 1 Then Exit Sub
If Target.Row < 4 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
...

bwait
05-06-2019, 10:31 PM
Thanks 大灰狼1976 !