urgent..how to go to the next row

  • Thread starter Thread starter shirley
  • Start date Start date
S

shirley

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
 
Hi
one way:
mysheet.Cells(ActiveSheet.Cells(Rows.Count,
"A").End(xlUp).Row,1).offset(1,0).Activate
 
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)
 
Back
Top