+ Reply to Thread
Results 1 to 3 of 3

When opening excel file, automatically open to view last entry or last blank cell

  1. #1
    Registered User
    Join Date
    11-27-2012
    Location
    Portland, Oregon
    MS-Off Ver
    Excel 2007
    Posts
    81

    When opening excel file, automatically open to view last entry or last blank cell

    Have an excel spread sheet with over 10,000 rows with fomulas and drop down lists that employees fill in name, part number, date & time and may make 10-15 entries a day; and then they save and close file.
    When the employee open file next day I would like the file to open to the last entry or to the next blank row so they do not have to scroll down 3 or 4 hundered rows to find the next blank row. Ctrl - End does not work as it takes me to row 10,000 where I have it formated too.

    Can anyone help!

    Thanks

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: When opening excel file, automatically open to view last entry or last blank cell

    Hi
    This code will select the first empty cell in column A

    Change the A65536 to B65536 if your data is in column B

    Please Login or Register  to view this content.
    If you want this done automatically then use the auto_open macro.


    Please Login or Register  to view this content.
    Installing the macro:

    Click on the developer tab
    Click Record Macro
    Click on this worksheet then ok

    Click on any cell

    Click on the developer tab
    Click Stop Recording

    Click on the developer tab
    Click Macro
    Select your macro then click on edit.

    Paste my code over the code that you see

    Close the window

    Save the Workbook as a macro enabled workbook.

    Enjoy

  3. #3
    Registered User
    Join Date
    11-27-2012
    Location
    Portland, Oregon
    MS-Off Ver
    Excel 2007
    Posts
    81

    Re: When opening excel file, automatically open to view last entry or last blank cell

    Thanks for the quick reply!
    Sorry but i failed to mention this is a shared woorbook. I tried following your install macro directions and it would not work due to being a shared workbook.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1