Select subset of named group in Excel

I have a named column named RESULT which I am processing in VBA. The first row of the RESULT column is a header and should be ignored from processing. What I am looking for is a way I can select a subset of a named group in Excel. In this case the named group is an entire column, and I want to select a subset of this group from row 2 to the last row of the spreadsheet. I am sure there must be an easy way of doing this?
Blowfelt82Asked:
Who is Participating?
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Connect With a Mentor Microsoft MVP ExcelCommented:
Hello,

try something along the lines of

Sub test()
Dim lrow As Long
   lrow = Cells(Rows.Count, Range("MyRange").Column()).End(xlUp).Row
   Range(Cells(2, Range("MyRange").Column()), Cells(lrow, Range("MyRange").Column())).Select
End Sub

Open in new window


cheers, teylyn
0
 
manthaneinCommented:
found  this on the web..

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

Open in new window

0
All Courses

From novice to tech pro — start learning today.