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!

Do you have headings in row 1?

If you do you should start your loops at 2 instead of 1.