+ Reply to Thread
Results 1 to 3 of 3

run-time error 13: type mismatch in VBA (Excel 2007)

  1. #1
    Registered User
    Join Date
    02-13-2012
    Location
    NYC
    MS-Off Ver
    Excel 2003
    Posts
    39

    run-time error 13: type mismatch in VBA (Excel 2007)

    hello,
    I'm writing a VBA program and receive "run-time error 13: type mismatch"

    this is the code in bold where it happens:
    Please Login or Register  to view this content.
    For clarification, FactorMA(nEMA) is an array of about 2 possible values a and b.

    I have all parts of the line defined as variables and I use that calculation as a constant in the next line.
    Can somebody tell me why I receive this error?
    Thanks.
    Last edited by zeno1; 04-20-2012 at 03:26 PM.

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,598

    Re: run-time error 13: type mismatch in VBA (Excel 2007)

    You need to post more code, we don't know how you have dim'd any of the variables in the post, nor what values they might be holding when the error crashes it.
    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    02-13-2012
    Location
    NYC
    MS-Off Ver
    Excel 2003
    Posts
    39

    Re: run-time error 13: type mismatch in VBA (Excel 2007)

    I resolved the message.
    Thank you for your help!
    Last edited by zeno1; 04-20-2012 at 06:11 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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