+ Reply to Thread
Results 1 to 2 of 2

Data mismatch type error

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

    Smile Data mismatch type 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.

    Here is my code
    Please Login or Register  to view this content.
    Here is the error

    Please Login or Register  to view this content.
    The error is thrown after this line

    Please Login or Register  to view this content.
    Any ideas?
    Attached Files Attached Files

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

    Re: Data mismatch type error

    Solved: I realized I had the wrong cells pasted into the wrong columns - easy fix!

+ 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. [SOLVED] Data Type Mismatch Error
    By kelseygueldalewis in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-06-2017, 12:53 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. 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. [SOLVED] 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