Results 1 to 3 of 3

Thread: Jump to Last Used Cell in a Column?

  1. #1
    Junior Member
    Join Date
    Aug 2017
    Posts
    11
    Rep Power
    0

    Jump to Last Used Cell in a Column?

    How do I jump to the last populated cell in a column?

  2. #2
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,401
    Rep Power
    10
    Assuming you want to jump to the last populated cell in a column using VBA

    Code:
    Worksheets("Name of sheet").Cells(Rows.Count, 1).End(xlUp).Select
    will do; where 1 is the column index (1=A, 2=B etc)
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook

  3. #3
    Junior Member
    Join Date
    Aug 2017
    Posts
    11
    Rep Power
    0
    Thanks for your reply. However, I need to move the cursor to that cell for data entry. I should have stated that.

    I've discovered how to do just what I want (& more).

    To move to the last cell in a contiguous block of blank or non-blank cells, simply double-click on the current cell's border. The border chosen will determine the direction of the move. If you're in the middle of a large block of data and you want to move to the top cell within that block of data, simply double-click the top border of the current cell. You'll know you're in the right place to double-click because the cursor will change to a four-headed arrow. If you want to move to the last cell to the right within that same block of data, double-click the current cell's right border. The same is true when moving to the left or down.

    In my situation, selecting the column & then double-clicking the cell's bottom border will take me to the desired cell.

Similar Threads

  1. Replies: 9
    Last Post: 02-01-2017, 06:04 PM
  2. Replies: 1
    Last Post: 12-21-2014, 09:29 PM
  3. Conversion Of Data In Column To One Cell
    By macak in forum Excel Help
    Replies: 6
    Last Post: 08-19-2013, 01:40 PM
  4. Highlight Active Cell’s Row and Column
    By Transformer in forum Tips, Tricks & Downloads (No Questions)
    Replies: 0
    Last Post: 05-17-2013, 12:32 AM
  5. Lookup From Cell Range By Matching Row and Column
    By paul_pearson in forum Excel Help
    Replies: 2
    Last Post: 03-07-2013, 02:02 PM

Tags for this Thread

Posting Permissions

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