GO TO in Excel
Hi,
You could put this in a general module and assign a button to it on the
workshhet
Sub GoToLastrow()
ActiveSheet.Cells(Rows.Count, "A").End(xlUp).Offset(1).Select
End Sub
Mike
"Em Ratty" wrote:
I am doing a long list of books on a workeet with 5 columns. I do not want to
sort it yet, I need to go to the first empty cell on column A (A 1200), or
the last cell with info. I do not want to go down 30 or more pages to get to
it. The Edit--GoTo--Special--Last line will take to column AE. HELP! Thanks,
em
|