Hi Carol,
Please put you complete question into the body of your posting.
A technique to get you to the bottom of the column, or to the next row
can be seen in You will want to paste the buttons to your toolbar for this
I think.
http://www.mvps.org/dmcritchie/excel/toolbars.htm#macro
Sub GotoBottomOfCurrentColumn()
'Tom Ogilvy 2000-06-26
Cells(Rows.Count, ActiveCell.Column).End(xlUp).Select
End Sub
The code for the next available cell at the bottom that you might
use in another macro would be something like the following though
you want to avoid selecting anything, but this is the how it works.
Cells(Rows.Count, ActiveCell.Column).End(xlUp).offset(1,0).Select