+ Reply to Thread
Results 1 to 4 of 4

Run time error type mismatch 13

  1. #1
    Registered User
    Join Date
    06-30-2010
    Location
    Newport New VA
    MS-Off Ver
    Excel 2003
    Posts
    97

    Run time error type mismatch 13

    getting this run time error 13 type mismatch


    here is the code

    Please Login or Register  to view this content.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Run time error type mismatch 13

    Please Login or Register  to view this content.

  3. #3
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,197

    Re: Run time error type mismatch 13

    Hi, Dariusd7,

    if you start at the first row a match is found and 0 is given to a row nunber (which is not available and will cause thee runtime error).

    Please Login or Register  to view this content.
    Ciao,
    Holger
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for you

  4. #4
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: Run time error type mismatch 13

    Putting in this little check lets you know what the problem is:

    Please Login or Register  to view this content.
    LastRowOnes is = 0. You can't select a row 0. The problem is occuring in your loop.

+ 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 Error 13 type mismatch
    By jamm_027 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-20-2012, 02:47 PM
  2. [SOLVED] Run-Time error 13 type mismatch
    By zplugger in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 06-07-2012, 08:13 PM
  3. Run-time error 13: Type mismatch
    By gregg141 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-02-2012, 05:22 PM
  4. Run-time error '13' Type mismatch
    By alepag in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-05-2010, 05:50 PM
  5. Run-time error '13':Type mismatch
    By Sibilia in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-03-2005, 03:54 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