A very basic syntax question about ranges

[Excel Ninja In Training]

The VBA line:

Range(Cells(Application.ActiveCell.SpecialCells(xlLastCell).Row, "E").Address).Select

works perfectly, selecting the cell in the "E" column of the last row in the worksheet with data in it.

So why doesn't the following select the range from E2 to that cell?

Range("E2:Cells(Application.ActiveCell.SpecialCells(xlLastCell).Row, "E").Address").Select

When I try it, I get a syntax error. I must be missing something blindingly obvious.

 

[jeffreybrown]

Then you could update to:

Sub SelectCells()
    Range("E2:E" & Range("A" & Rows.Count).End(xlUp).Row).Select
End Sub

 

[Excel Ninja In Training]

Jeff,

Thank you. That works great.

 

[jeffreybrown]

You're welcome...glad you got something you can work with

 

[Excel Ninja In Training]

Neil,

Sorry, just saw your 12:22 reply.

Your code now gives me the same result that Jeffrey's used to: only cells E1-E2 are selected, not E2-E376.

(Note: the content of this sheet changes, and sometimes the E column is completely empty.)

Here are the codes that have worked so far:
Range("E2:E" & ActiveCell.SpecialCells(xlLastCell).Row).Select
Range("E2:E" & Cells.SpecialCells(xlLastCell).Row).Select
Range("E2:E" & Range("A" & Rows.Count).End(xlUp).Row).Select

These all select E2-E376.