+ Reply to Thread
Results 1 to 6 of 6

When "IsError" doesn't catch error

  1. #1
    Registered User
    Join Date
    09-25-2008
    Location
    Winnetka, CA
    Posts
    83

    When "IsError" doesn't catch error

    If I put this formula into a cell:

    =SEARCH("I","Team")

    ...it would return a "#VALUE" error. When I put this line into code:

    Please Login or Register  to view this content.
    ...I'm not surprised that it gives an error message too. But if I try to trap the error with:

    Please Login or Register  to view this content.
    ...I still get an error message. Apparently VBA is so picky about that error, it won't even let IsError process it.

    The same thing happens with the Match function, and probably others that can give errors.

    Is there any way around this?

  2. #2
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Re: When "IsError" doesn't catch error

    May be
    Please Login or Register  to view this content.
    < ----- Please click the little star * next to add reputation if my post helps you
    Visit Forum : From Here

  3. #3
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    2,760

    Re: When "IsError" doesn't catch error

    Try this.

    Please Login or Register  to view this content.
    Click the * Add Reputation button in the lower left hand corner of this post to say thanks.

    Don't forget to mark this thread SOLVED by going to the "Thread Tools" drop down list above your first post and choosing solved.

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,463

    Re: When "IsError" doesn't catch error

    Or, maybe this:

    Please Login or Register  to view this content.

    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  5. #5
    Registered User
    Join Date
    09-25-2008
    Location
    Winnetka, CA
    Posts
    83

    Re: When "IsError" doesn't catch error

    Both of those work. Thanks.

    Skywriter, I've never seen that "bracket" notation you used:

    Please Login or Register  to view this content.
    Is that just for worksheet functions, or what?

  6. #6
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    2,760

    Re: When "IsError" doesn't catch error

    It's a shortcut for evaluate.
    You might use:
    X = Range("A1").value
    But this would work also:
    X = [A1]

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. runtime error 438 "object doesn't support this property or method"
    By lazyengineer in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-06-2015, 01:47 PM
  2. "Run time error 438, Object doesn't support this property or method."
    By dobracik in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-12-2015, 09:56 AM
  3. VBA "object doesn't support this property or method" error
    By mfortier3 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-08-2014, 09:37 PM
  4. Macro that changes # format doesn't work. Press "run," dialog box disappears, no error msg
    By OldManLearningExcel in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-04-2013, 11:42 PM
  5. [SOLVED] Experiencing "Run Time Error 438: 'Object doesn't support this property or method'"
    By BYizz in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-29-2013, 05:44 PM
  6. How to catch "<Application-defined or object-defined error>" in Excel 2010 VBA?
    By cjweitz in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-19-2013, 11:31 PM
  7. =IF(ISERROR(SEARCH("insurance",A125,1)),"","*")
    By cynichromantique in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-31-2006, 02:45 PM

Tags for this Thread

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