Hi
one way:
mysheet.Cells(ActiveSheet.Cells(Rows.Count,
"A").End(xlUp).Row,1).offset(1,0).Activate

--
Regards
Frank Kabel
Frankfurt, Germany

With the code below, i managed to go to the last row on a click of
the
button. However, i want to be directed to the empty row just below
the
last row when i click the button. How should i go about doing it?

Dim mysheet As Worksheet
Set mysheet = ActiveSheet

mysheet.Cells(ActiveSheet.Cells(Rows.Count, "A").End(xlUp).Row,
1).Activate


---
Message posted from http://www.ExcelForum.com/