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

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/

Hi Shirley,

Lots of ways. Here is one

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

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"shirley " wrote in message
...
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/