Consulting

Results 1 to 3 of 3

Thread: Skip heading rows with Range Offset

  1. #1
    VBAX Newbie
    Joined
    May 2019
    Posts
    4
    Location

    Skip heading rows with Range Offset

    Hi,
    In the snippet below, how can I skip 3 header rows and start the Range on B44?

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

  2. #2
    VBAX Mentor 大灰狼1976's Avatar
    Joined
    Dec 2018
    Location
    SuZhou China
    Posts
    452
    Location
    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
    ...

  3. #3
    VBAX Newbie
    Joined
    May 2019
    Posts
    4
    Location
    Thanks 大灰狼1976 !

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •