+ Reply to Thread
Results 1 to 4 of 4

Error 13 Type Mismatch in excel VB

  1. #1
    Registered User
    Join Date
    08-26-2013
    Location
    New Delhi
    MS-Off Ver
    Excel 2010
    Posts
    2

    Post Error 13 Type Mismatch in excel VB

    Hello Everyone,I have joined the forum today and am keen in learning and exploiting the super capabilities of the MS Excel tool.

    Can anyone tell me the best and the most efficient way of handling the subject Error.

  2. #2
    Valued Forum Contributor
    Join Date
    02-08-2012
    Location
    Newcastle, Australia
    MS-Off Ver
    Excel 2007 and Excel 2010
    Posts
    1,429

    Re: Error 13 Type Mismatch in excel VB

    Hi,

    Can you please upload the file that is receiving the error, so that I can take a look at your code in context.

    Thanks

  3. #3
    Registered User
    Join Date
    08-26-2013
    Location
    New Delhi
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Error 13 Type Mismatch in excel VB

    Hey Aj Ryan...

    Thanks for the prompt reply...but i could not resist root-causing the problem and consequently i detected the mistake i was committing.Actually the macro which i was actually supposed to call from the main macro of the Data Validation drop down sheet should contain all the checks and constraints instead of which I was handling those things in the Data Validation sheet macro.which was giving me that error 13 repeatedly.Finally I succeeded. Thanks anyways for your quick response again.
    Last edited by sid_excelforum; 08-27-2013 at 10:26 AM. Reason: some spelling mistakes

  4. #4
    Valued Forum Contributor
    Join Date
    02-08-2012
    Location
    Newcastle, Australia
    MS-Off Ver
    Excel 2007 and Excel 2010
    Posts
    1,429

    Re: Error 13 Type Mismatch in excel VB

    No worries.

    Can you please mark this thread as solved

+ 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. Excel VBA Run-time error '13' Type mismatch
    By pankajpm in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 12-27-2013, 05:34 AM
  2. Excel VBA Run-time error '13' Type mismatch
    By edgaryp in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-01-2013, 06:48 PM
  3. [SOLVED] Excel VBA Runtime Error 13 - Type Mismatch
    By mook25 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-01-2013, 07:30 AM
  4. type mismatch error-isplay value in excel
    By aman1234 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-02-2009, 06:50 AM
  5. Replies: 1
    Last Post: 04-28-2006, 12: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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1