+ Reply to Thread
Results 1 to 3 of 3

Mis match error?

  1. #1
    Registered User
    Join Date
    01-08-2015
    Location
    Canada
    MS-Off Ver
    2010
    Posts
    10

    Mis match error?

    Hey everyone,

    My friend helped me write a code, and I am trying to retrofit it to my document. Basically I have multiple lists of numbers associated to each day of the month over the period of a year. What I am trying to do is find the maximum value from each list for each month of the year. Please view the file, and of course, thanks ahead for the help!

    Mitch
    Attached Files Attached Files

  2. #2
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    4,991

    Re: Mis match error?

    mismatch error happens because the cell is blank when the error comes up (D45) changing .text to .value in your code would alleviate that problem, though I don't know if it will affect your results, I suggest trying it.
    Please help by:

    Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
    Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know

    There are 10 kinds of people in this world... those who understand binary, and those who don't.

  3. #3
    Registered User
    Join Date
    01-08-2015
    Location
    Canada
    MS-Off Ver
    2010
    Posts
    10

    Re: Mis match error?

    Thanks for the help, solved it!

+ 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] Vlookup to Pivot Table, using Match function, returns error if can't find match value
    By AndrewHowarth in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-16-2015, 12:10 AM
  2. [SOLVED] match error
    By cmccabe in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-14-2014, 05:42 PM
  3. Match N/A error
    By westafermn in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-07-2013, 10:41 PM
  4. Replies: 3
    Last Post: 05-02-2013, 01:31 AM
  5. Error with match in VBA
    By jrm0523 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-23-2012, 01:44 AM

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