LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default go last row when file is opened

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
file links incorrect when file is re-opened s-steege Excel Worksheet Functions 2 November 8th 08 11:26 PM
Use a cell to name a file to be opened. Michael Excel Worksheet Functions 3 June 30th 08 10:36 PM
When was file last opened? Frankie Excel Worksheet Functions 5 May 19th 07 08:28 PM
cannot open the excel file, the file is already opened cannot open the excel document Excel Discussion (Misc queries) 1 May 19th 06 07:45 AM
Copying the Editing in one file to Another opened XLS file Ahmad Excel Worksheet Functions 1 May 27th 05 02:04 PM


All times are GMT +1. The time now is 01:18 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"