+ Reply to Thread
Results 1 to 4 of 4

xldown=-4121=4, why?

  1. 04-12-2014, 08:18 PM #1
    ky4068
    ky4068 is offline
    Registered User
    Join Date
    03-09-2012
    Location
    china
    MS-Off Ver
    Excel 2007
    Posts
    16

    xldown=-4121=4, why?

    i want to know principle xldown(=4) constant in end property..

    originally, -4121..
    but ok 4, too..

    why?
    Reply With QuoteRegister To Reply
  2. 04-13-2014, 02:34 AM #2
    Leith Ross
    Leith Ross is offline
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,259

    Re: xldown=-4121=4, why?

    Hello ky4068,

    The number 4 goes back to the days of VB4. The function was Select.End(direction_num). The direction argument could be: 1 (Left), 2 (Right), 3 (Up), 4 (Down). These constants were kept for backward compatibility.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)
    Reply With QuoteRegister To Reply
  3. 04-13-2014, 08:31 PM #3
    ky4068
    ky4068 is offline
    Registered User
    Join Date
    03-09-2012
    Location
    china
    MS-Off Ver
    Excel 2007
    Posts
    16

    Re: xldown=-4121=4, why?

    Thanks very much Ross!
    Reply With QuoteRegister To Reply
  4. 04-13-2014, 11:34 PM #4
    Leith Ross
    Leith Ross is offline
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,259

    Re: xldown=-4121=4, why?

    Hello ky4068,

    You're welcome.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. xldown
    By secondrate in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-27-2010, 09:32 PM
  2. Xldown formula
    By chedges in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-10-2009, 07:03 AM
  3. End(xldown) not always going to last cell?
    By Duncan in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-04-2006, 05:35 AM
  4. Using xlDown as a function?
    By John Sutton in forum Excel General
    Replies: 4
    Last Post: 02-08-2006, 09:45 AM
  5. [SOLVED] repeated end(xldown)
    By R.VENKATARAMAN in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-28-2005, 02:45 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1