+ Reply to Thread
Results 1 to 2 of 2

Run Time error 13 Type Mismatch

  1. #1
    Forum Contributor
    Join Date
    07-20-2015
    Location
    Jacksonville, Florida
    MS-Off Ver
    Excel 2016
    Posts
    313

    Run Time error 13 Type Mismatch

    I am getting a runtime error 13 Type Mismatch when I run this code:

    [code] Dim OppPreRat As Long
    OppPreRat = Range("E" + I).Value[code/]

    Variable "I" is set to 3 and cell E3 is defined as number.

    I would appreciate any suggestion on resolving.

    Thank you

  2. #2
    Forum Contributor
    Join Date
    07-20-2015
    Location
    Jacksonville, Florida
    MS-Off Ver
    Excel 2016
    Posts
    313

    Re: Run Time error 13 Type Mismatch

    I apologize for this post - I found the problem caused by a typo. I will close this post

+ 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 bqheng in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-27-2015, 08:11 PM
  2. [SOLVED] Run-time error '13': Type mismatch
    By shiva_reshs in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-25-2013, 08:56 AM
  3. [SOLVED] Run-time error '13': Type mismatch
    By smonzon in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-19-2013, 12:42 AM
  4. [SOLVED] run-time error 13 type mismatch
    By ildestino in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-23-2012, 03:40 AM
  5. Run-time Error '13': Type mismatch
    By siamadu in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-13-2009, 09:58 AM
  6. Run Time Error '13':Type Mismatch
    By rms099k in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-05-2008, 03:37 PM
  7. [SOLVED] Run Time Error 13 Type Mismatch
    By ExcelMonkey in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-12-2005, 08: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