Results 1 to 22 of 22

Problem with understanding Type mismatch error?

Threaded View

  1. #1
    Forum Contributor
    Join Date
    05-08-2015
    Location
    Seattle, WA USA
    MS-Off Ver
    Excel 2013, 2016, Mac 2016
    Posts
    629

    Problem with understanding Type mismatch error?

    Hi all

    I am counting the days until Tsjallie returns from his vacation (He helps me on this project). In the mean time I am wondering if anyone can help me in my understanding of the Type mismatch Error? I understand that I need to match txt and numbers. I kinda understand that the data needs to come from like tables. I am wondering why I get the error on a seemingly simple sub as below;

    Screen Shot 2016-03-21 at 11.34.42 AM.png


    Screen Shot 2016-03-21 at 11.35.19 AM.png

    Maybe someone could suggest some reading that I could do that might clear it up in my head?

    I will attach the file if you want to take a look?
    Attached Files Attached Files
    Last edited by u3rick; 03-21-2016 at 03:31 PM.
    Have a great day!

    u3rick

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Problem with TabStrip code - Error Type Mismatch
    By imzhakmaya in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-08-2014, 08:14 AM
  2. [SOLVED] How to fix run-time error '13' type mismatch problem for my audit trail program?
    By ohlalayeah in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-30-2012, 11:37 PM
  3. [SOLVED] Merged cells cause "Runtime error 13 type mismatch" problem
    By Ralph Malph in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-07-2006, 08:55 AM
  4. Array problem: Key words-Variant Array, single-element, type mismatch error
    By davidm in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-09-2005, 01:54 AM
  5. Array problem: Key words-Variant Array, single-element, type mismatch error
    By davidm in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-08-2005, 12:30 AM
  6. [SOLVED] Help: Compile error: type mismatch: array or user defined type expected
    By lvcha.gouqizi in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-31-2005, 05:05 PM
  7. [SOLVED] Type mismatch error problem when dealing with Strings
    By David Goodall in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-30-2005, 09: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