Selecting Rows

C

Coolboy55

I want to select rows 3 to l_LastRow. I can't say Rows("3:l_LastRow"),
so what are my alternatives? Thanks!

This is what I have:
 
H

hideki

Did you mean want to select a row three row after the last row?

Sheets("Sheet4").Rows(lngLastRow + 3).Select
 
C

Coolboy55

I want to select rows 3 to lngLastRow (in this case, lngLastRow = 203).
But the value of lngLastRow may change in the future as items in the
table I'm creating are modified.
 
C

Coolboy55

I also will want to use xlLastCell to pick a range, as in,
Range("B3:xlLastCell"). How can I do that?

I'm basically creating a table for my data, along with background
shading. The data in the table will change occasionally, so the
borders and shading will need to be reapplied and resized as
necessary.

Am I doing it wrong?
 
H

hideki

So you want to select the range from B3 to the last cell? I think you
can try this syntax.

Range(Cells(3, "B"), Cells.SpecialCells(xlCellTypeLastCell)).Select
 
Top