Homepage |
IT Services |
Consulting |
Training |
Get help now |
Application Development |
Support and Downloads |
Contact Us |
Send us a comment or question |
Applications |
MS Access |
MS Excel |
Coding and Macros |
Excel VBA |
Select Current Region without Headers
Here is how to exclude first row from the entire currrent region selection. The key is to first select current region, then 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
Last modified on March 28 2020