Results 1 to 4 of 4

Thread: [RESOLVED] Excel - how to xlUp ?

  1. #1

    Thread Starter
    Don't Panic! Ecniv's Avatar
    Join Date
    Nov 2000
    Location
    Amsterdam...
    Posts
    5,343

    Resolved [RESOLVED] Excel - how to xlUp ?

    Hi,


    I used to use Range.end(xlUp) to move like pressing End button and up, but via code.

    In 2010, xlUp no longer exists. So uh... how do I use the .end properly?


    (weirdly all my old code running with the value in xlup still work fine from Access/Excel pre 2010)

    BOFH Now, BOFH Past, Information on duplicates

    Feeling like a fly on the inside of a closed window (Thunk!)
    If I post a lot, it is because I am bored at work! ;D Or stuck...
    * Anything I post can be only my opinion. Advice etc is up to you to persue...

  2. #2

    Thread Starter
    Don't Panic! Ecniv's Avatar
    Join Date
    Nov 2000
    Location
    Amsterdam...
    Posts
    5,343

    Re: [RESOLVED] Excel - how to xlUp ?

    Never mind - friday afternoon - I'm working in Powerpoint linking to an Excel so - xlup hasn't been defined (duuuuh!)

    Sorry people

    BOFH Now, BOFH Past, Information on duplicates

    Feeling like a fly on the inside of a closed window (Thunk!)
    If I post a lot, it is because I am bored at work! ;D Or stuck...
    * Anything I post can be only my opinion. Advice etc is up to you to persue...

  3. #3
    Just a Member! seenu_1st's Avatar
    Join Date
    Aug 2007
    Location
    India
    Posts
    2,170

    Re: [RESOLVED] Excel - how to xlUp ?

    do u mean to find last used row? if yes
    Code:
    Dim LastRow as long
    LastRow = Cells(Rows.Count, "A").End(xlup).Row
    Seenu

    If this post is useful, pls don't forget to Rate this post.
    Pls mark thread as resolved once ur problem solved.
    ADO Tutorial Variable types SP6 for VB6, MsFlexGrid fast fill, Sorting Algorithms


  4. #4

    Thread Starter
    Don't Panic! Ecniv's Avatar
    Join Date
    Nov 2000
    Location
    Amsterdam...
    Posts
    5,343

    Re: [RESOLVED] Excel - how to xlUp ?

    Yup thats what I was doing - but forgot I am in Powerpoint, so xlup isn't defined (doh!). Works fine - thanks for the assist!

    BOFH Now, BOFH Past, Information on duplicates

    Feeling like a fly on the inside of a closed window (Thunk!)
    If I post a lot, it is because I am bored at work! ;D Or stuck...
    * Anything I post can be only my opinion. Advice etc is up to you to persue...

Posting Permissions

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



Click Here to Expand Forum to Full Width