Results 1 to 5 of 5

type mismatched error 13 on general text ???

Threaded View

  1. #1
    Forum Contributor
    Join Date
    03-28-2017
    Location
    Thailand
    MS-Off Ver
    2013
    Posts
    241

    type mismatched error 13 on general text ???

    hi
    I have a loop that check the following :

    If ws3.range("D" & i).value = "DEBLOCK"  Then
    the cells in D has a formula :

    =IF(AND(B2 < 20%, C2 ="U"),"DEBLOCK","")
    the formula works perfect, the cell is not formatted (general)


    on a time that a DEBLOCK appear in a cell and the loop detects it, I get a debug window on the "IF" line

    Type mismatched error 13, and I see in watch window error 2042 variant/error


    anyone understand this ???

    Thanks
    Chris
    Last edited by incobart; 05-31-2018 at 08:35 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Code to highlight mismatched text between 2 columns
    By Uvuriel03 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-08-2017, 04:37 PM
  2. [SOLVED] wheres my type mismatched??
    By bdrilling33 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-10-2014, 08:30 AM
  3. [SOLVED] "Run-time error '13': type mismatch when running macro to add text to end of text
    By nrjordan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-18-2012, 10:34 PM
  4. converting dates to general type of data
    By Vogelmann in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-24-2012, 08:49 AM
  5. Format: General - Text - General
    By iturnrocks in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-11-2006, 11:50 AM
  6. [SOLVED] change pivot field of button type figure to general text
    By x taol in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-22-2006, 09:20 PM
  7. [SOLVED] User Type vs Class - General question:
    By Vacation's Over in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-19-2005, 03:05 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