Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Assuming Column A would contain the last row.
Private Sub Workbook_Open() ActiveSheet.Cells(Rows.Count, 1).End(xlUp) _ .Offset(1, 0).Select End Sub Right-click on the Excel Icon left of "File" on the worksheet menubar. Select "View Code" Paste the above into that module. Alt + q to return to the Excel window. Save and close. Reopen to find activecell at first blank cell below data in column A Gord Dibben MS Excel MVP On Tue, 2 Dec 2008 12:02:07 -0800, Wanna Learn wrote: Hello Whenever the workbook is opened I the cursor to go to the next empty row. How do I do that? thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
file links incorrect when file is re-opened | Excel Worksheet Functions | |||
Use a cell to name a file to be opened. | Excel Worksheet Functions | |||
When was file last opened? | Excel Worksheet Functions | |||
cannot open the excel file, the file is already opened | Excel Discussion (Misc queries) | |||
Copying the Editing in one file to Another opened XLS file | Excel Worksheet Functions |