Hello Elaine,

To find the row number of the last cell for a particular column, us
the following code...

With ActiveSheet
LastRow = Cells(.Rows.Count, "C").End(xlUp).Row
End With

To Select from A2 to the last row in Column A, use the following...

Range("A2:A" & LastRow).Select

Siincerely,
Leith Ros

--
Leith Ros
-----------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...fo&userid=1846
View this thread: http://www.excelforum.com/showthread.php?threadid=48771