With the code below, i managed to go to the last row on a click of th
button. However, i want to be directed to the empty row just below th
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).Activat

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