Hi Everyone!
Would like to know how to open an excel spreadsheet and automatically move
to the next new row without data..
Thanks,
Kevin
Hi Everyone!
Would like to know how to open an excel spreadsheet and automatically move
to the next new row without data..
Thanks,
Kevin
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
"Kevin Baker" <[email protected]> wrote in message
news:XFvce.335$Mp.178@lakeread02...
> Hi Everyone!
>
> Would like to know how to open an excel spreadsheet and automatically move
> to the next new row without data..
>
> Thanks,
> Kevin
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks