+ Reply to Thread
Results 1 to 5 of 5

Another....Run-Time Error 13 Type Mismatch

  1. #1
    Registered User
    Join Date
    12-10-2012
    Location
    Telford, PA
    MS-Off Ver
    Excel 2010
    Posts
    3

    Another....Run-Time Error 13 Type Mismatch

    All of a sudden I am getting "Run-Time Error 13 Type Mismatch" messages in a spreadsheet that has, to this point worked flawlessly. The debug process stops (and highlights) the If (c,Value) = 0 Then line. Any ideas?

    Please Login or Register  to view this content.
    Last edited by jeffreybrown; 12-10-2012 at 10:12 AM. Reason: Please use code tags...Thanks.

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,646
    What's in c when you get the error?
    If posting code please use code tags, see here.

  3. #3
    Registered User
    Join Date
    12-10-2012
    Location
    Telford, PA
    MS-Off Ver
    Excel 2010
    Posts
    3

    Question Re: Another....Run-Time Error 13 Type Mismatch

    Well, honestly, I wish I knew. I am not a programmer, and have been trying to figure out where that value is stored...

  4. #4
    Valued Forum Contributor
    Join Date
    11-15-2008
    Location
    ph
    MS-Off Ver
    2007/2010/2016
    Posts
    479

    Re: Another....Run-Time Error 13 Type Mismatch

    Hi -

    Check if you have formula error in your cells (ie; #N/A,#DIV/0!,etc)

    Regards,
    event

  5. #5
    Registered User
    Join Date
    12-10-2012
    Location
    Telford, PA
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Another....Run-Time Error 13 Type Mismatch

    Bingo! Found a bad reference! Thanks for the point in the right direction...

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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