In english   |   suomeksi

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

Back to Support and Downloads

News
 
Retrieve Your favorite (NYSE) Stocks with our Excel tool
Microsoft Excel, Access VBA Developing Services
IT Training
WEB Design and applications
Published advice on related questions
Populate a Multi-column Combobox with a 2D array on Access
Multiple Search Text at the same time using Forms in Microsoft Access Database
VBA comboBox multicolumn remove blank row and specific value listed
Articles
Time parameters for Google search
 

Search from our site:



Registered Microsoft Partner

Phone: +358 50 566 6858
Helsinki, Finland
mika.oukka@netti.fi