+ Reply to Thread
Results 1 to 6 of 6

Excel VBA Runtime Error 13 - Type Mismatch

  1. #1
    Registered User
    Join Date
    07-24-2013
    Location
    Southwest
    MS-Off Ver
    Excel 2003
    Posts
    26

    Excel VBA Runtime Error 13 - Type Mismatch

    Hi all,

    I have a VBA script which is designed to conditional format certain cells based on another cells dropdown selection however every time i run it i get the runtime 13 error. Now i know the formula is a big one within this macro however i've been told this is the only way I can get excel to conditionally format using this formula. Can someone help?

    I am using excel 2003 if that helps anyone. Thanks

    Please Login or Register  to view this content.
    I have asked this question on another forum which can be found here
    Last edited by mook25; 08-01-2013 at 06:48 AM.

  2. #2
    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,087

    Re: Excel VBA Runtime Error 13 - Type Mismatch

    Double up the quotes in the FIND; then it doesn't error:

    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


  3. #3
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: Excel VBA Runtime Error 13 - Type Mismatch

    Post Deleted
    Last edited by Kyle123; 08-01-2013 at 06:52 AM.

  4. #4
    Registered User
    Join Date
    07-24-2013
    Location
    Southwest
    MS-Off Ver
    Excel 2003
    Posts
    26

    Re: Excel VBA Runtime Error 13 - Type Mismatch

    Hmmm. This does stop the error however the conditional format formula does not complete it's action so the cells stay the same.

  5. #5
    Registered User
    Join Date
    07-24-2013
    Location
    Southwest
    MS-Off Ver
    Excel 2003
    Posts
    26

    Re: Excel VBA Runtime Error 13 - Type Mismatch

    Sorry wasn't aware of this, I have updated the 1st post as instructed. thanks

  6. #6
    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,087

    Re: Excel VBA Runtime Error 13 - Type Mismatch

    however the conditional format formula does not complete it's action so the cells stay the same.

    Different problem. For that we'd probably need to see the workbook. Maybe mark this as solved, because it is, and start a new thread.


    If you are satisfied with the solution(s) provided, please mark your thread as Solved.


    New quick method:
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

    Or you can use this way:

    How to mark a thread Solved
    Go to the first post
    Click edit
    Click Go Advanced
    Just below the word Title you will see a dropdown with the word No prefix.
    Change to Solved
    Click Save


    You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

+ 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 Type Mismatch
    By hungryhobo in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-08-2013, 08:50 PM
  2. Runtime Error 13 Type Mismatch
    By vtsoldier2010 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-30-2012, 12:59 PM
  3. RunTime Error 13 and Type Mismatch...
    By TheNewGuy in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-24-2010, 09:24 AM
  4. [SOLVED] Runtime Error Type 13 Mismatch
    By Linking to specific cells in pivot table in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-31-2006, 12:35 PM
  5. Runtime Error 13 - type mismatch
    By hindlehey in forum Excel General
    Replies: 1
    Last Post: 11-07-2005, 10:55 AM

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