Results 1 to 14 of 14

If statement .value type mismatch runtime error

Threaded View

  1. #1
    Forum Contributor
    Join Date
    06-28-2016
    Location
    Pennsylvania, USA
    MS-Off Ver
    2013
    Posts
    308

    If statement .value type mismatch runtime error

    Hi, I am having a little bit of trouble fixing a type mismatch error on some code.

    I've tried rewriting it a few ways, but keep getting the same error.

    code is below:

    dim c as range
    
    If c.offset(1).value <> "" And c.value = 1 Then
    This is probably a very simple solution, but I am not versed in VBA enough to come to it on my own.

    Thanks in advance.
    Last edited by TheN; 04-10-2017 at 04:06 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Runtime Error 13 - Type Mismatch
    By trobb in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-17-2017, 02:06 AM
  2. Type mismatch runtime error 13
    By kalyanr12 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-08-2014, 04:09 PM
  3. runtime error 13 type mismatch
    By hughesy8290 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-28-2013, 11:18 AM
  4. Runtime Error 13 Type Mismatch
    By vtsoldier2010 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-30-2012, 12:59 PM
  5. runtime error '13' type mismatch
    By longhorn23 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-18-2010, 04:53 PM
  6. Runtime Error Type 13 Mismatch
    By Linking to specific cells in pivot table in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-31-2006, 12:35 PM
  7. [SOLVED] Runtime Error '13': Type mismatch
    By Linking to specific cells in pivot table in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-18-2005, 03:06 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