Excel VBA · Quick Guide

Select Current Region without Headers

How to exclude the header row from an Excel VBA CurrentRegion selection.

Here is how to exclude the first row from the entire CurrentRegion selection. The key is to first select the current region, move the selection down by one row and then resize the moved area one row shorter.

Sub SelectCurrentRegionWithoutHeaders()
    Dim tbl As Range

    Set tbl = Sheet1.Range("A6").CurrentRegion

    tbl.Offset(1, 0) _
       .Resize(tbl.Rows.Count - 1, tbl.Columns.Count) _
       .Select
End Sub