Type Mismatch Error

Hello,

I am very new to VBA Programing and am still learning my way around things. I know that there is a Type Mismatch error on the Clocksum line but am not sure why. Any tips, pointers, or fixes would be greatly appreciated!

Please Login or Register  to view this content.

Do you have some sample data that I can throw onto the sheet so that it doesn't fall out of the If loop? It runs right through for me without any data.

What do you have in mind for this(code/worksheet) to do for you?
Add up all of the hours for each clocknum, then highlight a row that meets the criteria in the loops?

edit: clocksum = 0 but I think it is because the SUMPRODUCT(A2,F2,Q2,R2) isn't giving you what you want. Doing this manually you get a VALUE# error because R2 is the wrong type of data.

re: =SUMPRODUCT(A2,F2,Q2,R2)

R2 = "WK1" and is a string, so how does that work in the SUMPRODUCT formula?

Decoderman,

I'm going through this thread trying to find what the issue is. At one point you were asked what the purpose of the macro is:

Originally Posted by Decoderman

The worker has a set number of hours that they should be working. If they work less than that I want to see if they assigned it to the correct Pay Code:

4242 : 40 hrs
4000: 32 hrs
8005: 12 hrs

In that order. The FF Man has a different set of hours.

Does that clear anything up?

If it isn't charged correctly I want the entire row highlighted.

So I looked at the TestData you attached, and what I'm seeing is that you want the macro to do the following:

• Check the total hours of each employee

• If the total hours >40, the paycode should be 4242
• If 40 > totalhours > 32, the paycode should be 4000
• If 32 > totalhours > 12, the paycode should be 8005

• If any of the paycodes are not correct, highlight the entire row

With that information, I don't see that sumproduct is necessary at all. Here's the code I came up with to make that happen. Attached is a modified version of your TestData so you can see how it works.

Please Login or Register  to view this content.

Let me know if I have it wrong or the macro needs to do something else/more (I wasn't sure what you meant by "The FF Man has a different set of hours").

Hope this helps,
~tigeravatar

I think this is what you were after originally:

Please Login or Register  to view this content.