+ Reply to Thread
Results 1 to 3 of 3

Type Mismatch error with a range value

  1. 08-31-2015, 01:30 PM #1
    Coleman34
    Coleman34 is offline
    Registered User
    Join Date
    08-27-2014
    Location
    Albany, NY
    MS-Off Ver
    Office 2010
    Posts
    91

    Type Mismatch error with a range value

    I am getting an error when I run this list comparison tool. It is something I found online, so it is not of my making but I am getting a type mismatch error. I have debugged and traced it down to this line:

    Please Login or Register  to view this content.
    Can anyone be of any help pointing me in the right direction?

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  2. 09-02-2015, 04:45 AM #2
    tehneXus
    tehneXus is offline
    Valued Forum Contributor tehneXus's Avatar
    Join Date
    04-12-2013
    Location
    Hamburg, Germany
    MS-Off Ver
    Work: MS-Office 2010 32bit @ Win8 32bit / Home: MS-Office 2016 32bit @ Win10 64bit
    Posts
    944

    Re: Type Mismatch error with a range value

    Hi,

    for me the code runs without an error, could you upload some example data that cause the error?
    Please use [CODE]-TAGS
    When your problem is solved mark the thread SOLVED
    If an answer has helped you please click to give reputation
    Read the FORUM RULES
    Reply With QuoteRegister To Reply
  3. 09-02-2015, 09:02 AM #3
    Kaper
    Kaper is offline
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,623

    Re: Type Mismatch error with a range value

    This happens probably when your last dictionary used to fill varItems
    Please Login or Register  to view this content.
    has only one element in it
    then 
    Please Login or Register  to view this content.
    is 0 (despite option base :-( ) and obviously this is not valid for resize.
    Best Regards,

    Kaper
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Using Range.clearcontents causing type mismatch error in code
    By Captian LDS in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-28-2014, 04:54 PM
  2. .Range.Value Type Mismatch Error
    By bishoposiris in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-02-2014, 10:27 AM
  3. Type Mismatch error when calculating a set of functions on a multiple range
    By AnnaDana in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-20-2013, 02:27 PM
  4. Type mismatch error assigning range to array......
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 02-11-2012, 06:27 PM
  5. Range and Find function error: Type Mismatch
    By VBNewb in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-07-2011, 02:10 PM
  6. Type mismatch error 13: Transpose dynamic name range when range refers to single cell
    By asha3010 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-27-2010, 10:58 AM
  7. Type Mismatch error & subscript out of range error
    By Jeff Wright in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-14-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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1