How do you go to the last row containing data in an excel sheet?

D

David McRitchie

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
 
Top