Type Mismatch Error for writing text in a cell

I'm writing a code that counts the number of cells with the words "no item placed" in a column. I'm also having the code count the total number of cells in the column. Then to have it calculate the percent of unplaced cells. In the end, the code should write a statement in the second row of each column that says "X unplaced cells, X %". X = count/percent. the code works until the line NumUnplaced.Value = Count + " unplaced items, " + percentUnplaced + "%" where I get a type mismatch error. I think it's because NumUnplaced is a Range and the other two our data values. Any ideas on how to fix this?

Please Login or Register  to view this content.

Please use CODE tags. As for your problem, I don't think it is a mathematical one
Replace

Please Login or Register  to view this content.

with

Please Login or Register  to view this content.

This will format the percentage to a whole percent if that's what you want.

Please Login or Register  to view this content.