Open Excel and move to next row

[Kevin Baker]

Hi Everyone!

Would like to know how to open an excel spreadsheet and automatically move
to the next new row without data..

Thanks,
Kevin

 

[Otto Moehrbach]

This macro will execute on opening of the file. It will select MySheet and
it will select the cell below the last entry in Column A. Depending on your
data layout, the active cell may well be off the screen. If this is the
case, post back and tell us what cell you want at the top left of the screen
on opening. This macro is a workbook event macro and must be placed in the
workbook module. To do this, open the workbook, right-click on the Excel
icon immediately to the left of the word File in the menu across the top of
the screen, and select View code. Paste this macro into the displayed
module. HTH Otto
Private Sub Workbook_Open()
Sheet("MySheet").Select
Range("A" & Rows.Count).End(xlUp).Offset(1).Select
End Sub