Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: "END" of spreadsheet.

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Location
    Mike
    Posts
    796
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I know that CTRL/END takes me to the last cell in the S-Sheet. Can that be changed?

    In other words my sheet really ends at lets say G40 not H50. I tried deleting rows 41 thru 50 but that still takes me to H50.

    I'm trying to write a macro to automatically set my print area based on the "actual" end of sheet.

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Did you save your worksheet after deleting the rows? Hint... hint.

    [ This Message was edited by: Mark W. on 2002-02-27 10:28 ]

  3. #3
    New Member
    Join Date
    Feb 2002
    Posts
    14
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Yeah, annoying isn't it?!
    Here's a couple of ideas...

    Try holding down 'End' and pressing the 'Down' arrow to get to the end of your data? (If it works, then record a macro while you do it to see what the command is)

    Or try the .UsedRange property of the worksheet.

Some videos you may like

User Tag List

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
  •