Selecting Last Empty Row / Certain Columns

[RigasMinho]

Hey,
I have this where it finds the last empty cell
Worksheets(Sheet10.Name).Cells(Rows.Count, 1).End(xlUp).Select
ect
basically it selects the last empty cell in the worksheet.

However I need it to select the last empty row but only columns
A/B/C/D/E

I tried changing it to

Worksheets(Sheet10.Name).Range("A:E").End(xlUp).Select
but that does no go.

Any ideas?

 

[PCLIVE]

Try something like this:

r= Worksheets(Sheet10.Name).Cells(Rows.Count, 1).End(xlUp).row
Worksheets(Sheet10.Name).Range("A" & r & ":E" & r ).Select

 

[Guest]

Worksheets(Sheet10.Name).Cells(Rows.Count, 1).End(xlUp).Resize(1,5).Select