move down one row

  • Thread starter Thread starter Truseeker
  • Start date Start date
T

Truseeker

I'm trying to write a macro that goes to the first blank cell at the end of
a column.

I found Selection.End(xlDown).select this gets me to the end of the list
but I can't figure out what to add to move down 1 row.

If there is another way to do the same thing please tell me.

Thanks in advance for the help
 
Selection.End(xlDown).Offset(1,0).Select

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Truseeker,

If your column has no empty cells along the way, you can use one of these:

Range("A1").End(xlDown).Offset(1, 0).Select
Range("A1").End(xlDown).Range("A2").Select

If there are empty cells along the way, and you want to get to the last
cell:

Cells(Rows.Count, 1).End(xlUp).Offset(1, 0).Select
 
Back
Top