Open workbook to same worksheet and next empty row

  • Thread starter Thread starter inta251 via OfficeKB.com
  • Start date Start date
I

inta251 via OfficeKB.com

To open workbook to same worksheet I using macro

Private Sub Workbook_Open()
Sheets (“tripsâ€).Select
End Sub

Is that possible add to this macro,
open to the next empty row or next empty cell in Column A?

Thanks in advance.
Sincerely, Igor. (inta251)
 
Amended code below assuming no blanks in column A

Private Sub Workbook_Open()
Sheets (“trips”).Select
ActiveSheet.Cells(Rows.Count, 1).End(xlUp) _
.Offset(1, 0).Select
End Sub

Assuming first blank cell down.

Private Sub Workbook_Open()
Sheets("trips").Select
Range("A1").End(xlDown).Offset(1, 0).Select
End Sub
Is that possible add to this macro,
open to the next empty row or next empty cell in Column A?

Thanks in advance.
Sincerely, Igor. (inta251)
Click to expand...


Gord Dibben MS Excel MVP
 
Yes but we really have to know the data layout. Suppose that before the next
empty row there is data in all the cells of column A, then the code would be
[A1].End(XLDown).Offset(1,0).Select
 
Thanks for respond.
Both formulas working for me perfectooo.
THANKS again.
Good weekend.
Sincrely, Igor (inta251)
 
Back
Top