+ Reply to Thread
Results 1 to 6 of 6

Highlighted cell on next empty row in Column B after save

  1. #1
    Registered User
    Join Date
    12-08-2009
    Location
    Silver Spring, MD
    MS-Off Ver
    Excel 2003
    Posts
    20

    Highlighted cell on next empty row in Column B after save

    Hello!

    I would like for the cursor/cell highlighted to always be the next empty row in Column B when my document is closed and then reopened.

    Any advice? Thanks!

  2. #2
    Valued Forum Contributor blane245's Avatar
    Join Date
    02-20-2009
    Location
    Melbourne, FL
    MS-Off Ver
    Excel 2010
    Posts
    649

    Re: Highlighted cell on next empty row in Column B after save

    You didn't say which worksheet you are interested in, but assuming that it is the first one, use the following:

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    12-08-2009
    Location
    Silver Spring, MD
    MS-Off Ver
    Excel 2003
    Posts
    20

    Re: Highlighted cell on next empty row in Column B after save

    Do I just copy and paste exactly as you have above?

    I just realized... I do have multiple worksheets in my workbook. I'd like for this to apply to only one of the workbooks (for now?). That workbook is named FY2010. That's the only workbook that will be used for this year.

  4. #4
    Valued Forum Contributor blane245's Avatar
    Join Date
    02-20-2009
    Location
    Melbourne, FL
    MS-Off Ver
    Excel 2010
    Posts
    649

    Re: Highlighted cell on next empty row in Column B after save

    If you want this to apply to a single worksheet, past the following code into that sheet:
    Please Login or Register  to view this content.
    Bob
    Click my star if my answer helped you. Mark the thread as [SOLVED] if it has been.

  5. #5
    Registered User
    Join Date
    12-08-2009
    Location
    Silver Spring, MD
    MS-Off Ver
    Excel 2003
    Posts
    20

    Re: Highlighted cell on next empty row in Column B after save

    Didn't work. Any other ideas? :o)

  6. #6
    Valued Forum Contributor blane245's Avatar
    Join Date
    02-20-2009
    Location
    Melbourne, FL
    MS-Off Ver
    Excel 2010
    Posts
    649

    Re: Highlighted cell on next empty row in Column B after save

    Please send me your excel file so I can see what you did.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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