+ Reply to Thread
Results 1 to 5 of 5

VBA Run time error 13 type mismatch in Excel 2010 with Datavalidation & VBA

  1. #1
    Registered User
    Join Date
    03-02-2017
    Location
    India
    MS-Off Ver
    2010
    Posts
    4

    VBA Run time error 13 type mismatch in Excel 2010 with Datavalidation & VBA

    I am absolutely new to excel VBA.

    I have a requirement to create an excel to maintain status of orders (there are about 6 / 7 order statuses (2 of which are OrderStatus(no status), Enquiry and taken as samples here ) and based on each status, a specific set of actions have to be performed. I have created the excel in which there are multiple columns & rows, some of the columns have data validations either from a reference sheet or entered as list in the Data validation part and some have formula references.

    What little coding I could understand, I have done that based on my teeny weeny bit of knowledge + the ideas that I got from checking on various websites. As a result, I am not sure if I have a robust code, although, I have some piece of coding to perform certain actions based on values change in certain columns.

    Following are the issues that I want help with:

    When inserting / deleting row / rows, get error "Type Mismatch error 13"
    The same error appears while certain columns are extended down to the cells.
    Same error while cut copy pasting a row
    Although the run time error occurs, the action is partially completed

    Earliest response would be much appreciated.

    My sample excel is attached
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    5,517

    Re: VBA Run time error 13 type mismatch in Excel 2010 with Datavalidation & VBA

    When you are making changes to your sheet, Target (the range being changed) can be multi-celled. But your code relies on it being a single cell, so try putting this line just after your declarations:


    If Target.Cells.Count > 1 Then Exit Sub
    Bernie Deitrick
    Excel MVP 2000-2010

  3. #3
    Registered User
    Join Date
    03-02-2017
    Location
    India
    MS-Off Ver
    2010
    Posts
    4

    Re: VBA Run time error 13 type mismatch in Excel 2010 with Datavalidation & VBA

    This has been resolved now. Thanks

  4. #4
    Forum Expert
    Join Date
    02-14-2009
    Location
    .
    MS-Off Ver
    ................
    Posts
    2,840

    Re: VBA Run time error 13 type mismatch in Excel 2010 with Datavalidation & VBA

    Yes, it was...

    http://www.ozgrid.com/forum/showthread.php?t=203108

    Please read the forum rules, both here and on OzGrid.

  5. #5
    Registered User
    Join Date
    03-02-2017
    Location
    India
    MS-Off Ver
    2010
    Posts
    4

    Re: VBA Run time error 13 type mismatch in Excel 2010 with Datavalidation & VBA

    I hv posted this on multiple sites, and was informed that cross posting is to be avoided.
    Like many novices, I wasn't aware of this as this is my second post.

    I would like to rectify that situation. My original post can be found in the below link. Please reply to the same there.

    http://chandoo.org/forum/threads/vba...3/#post-199415

    Thanks

+ 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. Run-Time Type 13 Mismatch Error help - Excel VBA
    By ShakJames in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-08-2015, 06:19 AM
  2. Excel VBA Run-time error '13' Type mismatch
    By svibuk in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-01-2014, 04:23 AM
  3. 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
  4. [SOLVED] Excel VBA Run-time error '13' Type mismatch
    By mackypogi in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-17-2013, 02:15 AM
  5. Error 13 type mismatch in excel 2010
    By excelbugs_help in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-29-2013, 05:56 AM
  6. 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
  7. Excel 2010 (Run-time error '13' type mismatch) "Debug" and "Continue" Grayed out.
    By Jeronimo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-18-2012, 06:42 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