Results 1 to 2 of 2

Selection.End(xlDown) Function

This is a discussion on Selection.End(xlDown) Function within the Excel Questions forums, part of the Question Forums category; (1) If you use Selection.End(xlDown).Select you are suppose to get the last entry in a row/column; however, this selection does ...

  1. #1
    Board Regular
    Join Date
    Jun 2002
    Posts
    77

    Default

    (1) If you use Selection.End(xlDown).Select you are suppose to get the last entry in a row/column; however, this selection does not work in my program/macro when the specified sheet only has entrries in the first row.(works for other worksheets) Instead it goes to last empty cell. Can you help?

  2. #2
    MrExcel MVP Russell Hauf's Avatar
    Join Date
    Feb 2002
    Location
    Beaverton, OR USA
    Posts
    1,455

    Default

    How about:

    Cells(65536,1).End(xlUp).Select

    (change 1 to the column you wish to select the last entry in - A=1,B=2, etc.).

    -rh

    [ This Message was edited by: Russell Hauf on 2002-06-14 12:24 ]

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com