+ Reply to Thread
Results 1 to 3 of 3

Data Type Mismatch Error

  1. #1
    Registered User
    Join Date
    07-16-2014
    Location
    Seattle, WA
    MS-Off Ver
    2013
    Posts
    64

    Question Data Type Mismatch Error

    I'm working on a project to add up the width of rolls (WIDTH ORD) from a given parent roll identified by LENGTH. I only want to analyze parent rolls that have associated pattern numbers that are not integers. i.e. analyze rows with values 5.1, 6.2 but not 5, 6, 7 etc.

    I added an excel file with some column values deleted for ease of reading.

    Here is my full code

    Please Login or Register  to view this content.
    I'm getting a mismatch type error at these parts

    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    Could it be that the Cells.Value data type doesn't match the Int() data type?
    In that case I don't know how to change either one of the data types.
    Any help would be much appreciated!
    Attached Files Attached Files
    Last edited by kelseygueldalewis; 04-06-2017 at 11:49 AM.

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,601

    Re: Data Type Mismatch Error

    Do you have headings in row 1?

    If you do you should start your loops at 2 instead of 1.
    If posting code please use code tags, see here.

  3. #3
    Registered User
    Join Date
    07-16-2014
    Location
    Seattle, WA
    MS-Off Ver
    2013
    Posts
    64

    Re: Data Type Mismatch Error

    Yes that worked! There are some other bugs but I will post a new thread related to those. Thanks Norie!

+ 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. Data Type mismatch error while using Like in access query
    By teco in forum Access Tables & Databases
    Replies: 5
    Last Post: 01-26-2017, 04:36 PM
  2. Data Type Mismatch Error on Open Recordset
    By masouder in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-15-2016, 11:56 AM
  3. Type Mismatch Error in Data Entry Form
    By sj9ers in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-01-2016, 12:43 PM
  4. type mismatch Error when writing data to excel
    By svibuk in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-11-2013, 07:07 AM
  5. Type Mismatch Error on Large Data Sets
    By erock24 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-04-2010, 04:40 PM
  6. [SOLVED] type mismatch error-copies data from one sheet to another
    By Marcotte A in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-30-2005, 10:25 PM
  7. Type Mismatch Error when getting data from another workbook
    By Tony Zappal in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-12-2005, 07:06 PM

Tags for this Thread

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