Selection of rows (variable)

[cmazur71]

I want to select a group of rows, depending on how many are in my spreadsheet
I set 'a' to equal the number of rows...now I need to select rows 2 thru a, but I cannot figure out the formatting. How do I do this?

a = Worksheets("Final").Cells(Rows.Count, 1).End(xlUp).Row
Rows("2:" & a).Select

 

[Fluff]

How about

Dim a As Long
Worksheets("Final").Select
a = Cells(Rows.Count, 1).End(xlUp).Row
Rows("2:" & a).Select

 

[cmazur71]

How about

Dim a As Long
Worksheets("Final").Select
a = Cells(Rows.Count, 1).End(xlUp).Row
Rows("2:" & a).Select

I'm getting an error when i get to the Rows command: Run Time Error 1004 Select Method of Range class failed:

Dim endrow As Long
Worksheets("Final").Range("A1").Select
endrow = Cells(Rows.Count, 1).End(xlUp).Row
Rows("2:" & endrow).Select

 

[Fluff]

This line

Worksheets("Final").Range("A1").Select

should be

Worksheets("Final").Select