Select the current region excluding the top row

D

DZ

Hi

I want to select the current region excluding the top row
The following did not work

Selection.CurrentRegion.Resize(-1, 0).Select

Can someone help me ?
 
R

RyanH

This assumes you have only 1 Row as your header if that changes just change
the 1 to however many rows you need as your header.

Sub SelectRange()

Dim myRange As Range

Set myRange = ActiveCell.CurrentRegion

myRange.Offset(1, 0).Resize(myRange.Rows.Count - 1,
myRange.Columns.Count).Select

End Sub


Hope this helps! If so, please give us credit.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Select current region less 2 rows at the top 2
Macro to select and delete levels of a document 2
How do I exclude a cell from a range? 4
Page Break when a column changes 4
Paragraph numbering in Word 1
Select 'used range' except header row in excel 2007 3
Need Help with a VBA subroutine 0
Code to add comments to selected cells within a selected range 30

Top