Runtime error 13 - Type Mismatch

[breechd]

I have an excel spreadsheet that has a list of names in Column A (rows 2 through 6). It has a list of categories in Row A (B through X). In my code I identified the person names with NameItem and the categories with CatItem and defined both as Variant in Module 1. I am struggling with why my sheet calculates only into the Unknown column when it seems my code is correct. Any thoughts on how to troubleshoot this issue? Any ideas would be welcome. Thanks much!

 

[breechd]

I will try it and let you know if I have success. Thank you so much for all your help!

 

[breechd]

rorya, I am still experiencing the type mismatch 13 error even after the changes you suggested. Any thoughts?

 

[bobsan42]

If Not Module1.AddValue(NameItem:=Sheet11.Cells(lngRow, 1), CatItem:=Sheet11.Cells(lngRow, 2), lngScore:=Sheet11.Cells(lngColumn, 2)) Then
MsgBox "An error resulted in trying to add this value", vbCritical, "Error"

this is confusing me.
could you please post your current code and if possible indicate exactly when the error appears and confirm the error Number.

 

[RoryA]

Need to see your current code and to know the values of the row and column variables, as well as the values in those cells.