+ Reply to Thread
Results 1 to 2 of 2

Run Time Error '13" Type mismatch

  1. #1
    Registered User
    Join Date
    09-06-2017
    Location
    San Francisco
    MS-Off Ver
    Microsoft® Excel® for Microsoft 365 MSO (Version 2201 Build 16.0.14827.20158) 64-bit
    Posts
    12

    Run Time Error '13" Type mismatch

    Hello,
    I am getting the following message as a result of running the below Macro. I did not write this macro but found in on on the Internet and tried to modify it to meet my needs. Would anyone have an idea of what I would need to change in order to prevent the Run Time Error '13' Type mismatch from occurring.
    Please Login or Register  to view this content.
    Last edited by tseelu; 02-28-2022 at 04:30 AM.

  2. #2
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent Monthly Channel / Insiders Beta
    Posts
    8,911

    Re: Run Time Error '13" Type mismatch

    I don't know where you found that code, but I wouldn't go back there. You want something like:

    Please Login or Register  to view this content.
    Rory

+ 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. [SOLVED] Second Find is returning Type Mismatch "Run time error 13"
    By jprlimey in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 05-22-2019, 12:43 PM
  2. [SOLVED] "Run time Error '13, Type mismatch issue - please help
    By lukasz_W in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-08-2015, 03:59 AM
  3. Replies: 12
    Last Post: 11-24-2014, 10:22 AM
  4. 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
  5. [SOLVED] How to fix "Run-time error 13, type mismatch" when vlookup return value of #N/A?
    By ohlalayeah in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-02-2012, 02:01 AM
  6. [SOLVED] VBA Excel 2007 : Autofit Merge Cells Error "Run-time error '13': Type Mismatch"
    By Hudas in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-18-2012, 04:10 PM
  7. Error Handling to mitigate "Run Time Erorr 13 Type Mismatch"
    By ExcelMonkey in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-16-2005, 09:05 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