+ Reply to Thread
Results 1 to 2 of 2

Run -time error '13': Type mismatch

  1. #1
    Registered User
    Join Date
    08-04-2016
    Location
    india
    MS-Off Ver
    2007
    Posts
    4

    Run -time error '13': Type mismatch

    Hi,

    I am receiving run time error '13' on executing the macro. It was running fine earlier, no idea why its failing now. The code is as below. Have marked the statement RED where its failing for easy tracking. Please suggest.

    Please Login or Register  to view this content.

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2405
    Posts
    25,078

    Re: Run -time error '13': Type mismatch

    At the point that the error occurs, what are the values of

    iColCount
    irow1
    wsCMSRSC.Cells(irow1, iColCount)
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ 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 mlexer70 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 06-21-2016, 11:42 AM
  2. [SOLVED] Run time error '13' - type mismatch
    By monkeypants in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-12-2016, 12:26 AM
  3. [SOLVED] Please help with Run-Time error 13 Type Mismatch
    By alec66317 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-14-2012, 08:29 AM
  4. Run-time error 13 (Type Mismatch)
    By prajesh in forum Excel General
    Replies: 11
    Last Post: 11-15-2011, 05:43 AM
  5. Run Time Error '13'. Type Mismatch
    By TonyforVBA in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-08-2010, 09:29 AM
  6. Type mismatch Run-time Error 13
    By auber in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-27-2009, 10:46 AM
  7. run-time error 13 type mismatch
    By godster84 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-27-2007, 11:29 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