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
I'm getting a mismatch type error at these parts
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!
Bookmarks