In english   |   suomeksi

IT Services
Get help now
Application Development
Support and Downloads
Contact Us
Send us a comment or question
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

Back to Support and Downloads

Retrieve Your favorite (NYSE) Stocks with our Excel tool
Microsoft Excel, Access VBA Developing Services
IT Training
WEB Design and applications
MSDN ExcelBlog
MSDN AccessBlog
Time parameters for Google search

Search from our site:

Registered Microsoft Partner

Phone: +358 50 566 6858
Helsinki, Finland