+ Reply to Thread
Results 1 to 7 of 7

Run-time error '424': Wrong value returned

  1. #1
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    16,072

    Run-time error '424': Wrong value returned

    I have part of the code in userform:

    Please Login or Register  to view this content.
    MsgBox return propper number (like 24, or 5)
    x return 0

    Error us:

    Run-time error '424':
    Object required


    Why would that be?
    Last edited by zbor; 05-09-2012 at 09:44 AM.
    Never use Merged Cells in Excel

  2. #2
    Forum Expert
    Join Date
    07-16-2010
    Location
    Northumberland, UK
    MS-Off Ver
    Excel 2007 (home), Excel 2010 (work)
    Posts
    3,054

    Re: Run-time error '424': Wrong value returned

    Because 'Application' has 2 p's in it - i.e. not "Aplication"

  3. #3
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    16,072

    Re: Run-time error '424': Wrong value returned

    Nice :P
    But returns the same

  4. #4
    Forum Expert
    Join Date
    07-16-2010
    Location
    Northumberland, UK
    MS-Off Ver
    Excel 2007 (home), Excel 2010 (work)
    Posts
    3,054

    Re: Run-time error '424': Wrong value returned

    It's still giving an Object Required error or it's still return 0?

    Does it make a difference if you define x as a variant? It shouldn't, but that's where I'd start.

  5. #5
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    16,072

    Re: Run-time error '424': Wrong value returned

    Still return 0... But now Run time error 13.. let me check a little bit...

  6. #6
    Forum Expert
    Join Date
    07-16-2010
    Location
    Northumberland, UK
    MS-Off Ver
    Excel 2007 (home), Excel 2010 (work)
    Posts
    3,054

    Re: Run-time error '424': Wrong value returned

    You're getting an error 13 (type mismatch) trying to put a value into a variant? Now *that's* impressive!

  7. #7
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    16,072

    Re: Run-time error '424': Wrong value returned

    No, I didn't put it into variant at all
    There was some error in the range...

    aPPlications solved previous error, and now I fixed second one

    Thx

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1