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
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