VBA Select active rows

[jerryneubauer]

I want to select all the active rows in my spreadsheet starting with row 4. Columns A-I are populated.

This is what i have so far, but it's wrong:

ActiveSheet.Range ("A4:I" & Range("A" & Rows.Count).End(xlUp).Select)

Thanks.

 

[Joe4]

There are various ways to do it, but the one that probably most closely resembles the method you were trying is this:

ActiveSheet.Range("A4:I" & Range("A" & Rows.Count).End(xlUp).Row).Select

 

[jerryneubauer]

Thanks.