error 13 type mismatch - any idea ??

[Blue_kul]

I am getting this error, in attached worksheet, i tried to format all the cells accordingly but still getting same error.Test File.xlsm

[Blue_kul]

ok got it .. one of the cell was having space i guess i filtered all empty cells and deleted data if any and it worked... btw any idea if we can achieve it using any excel function ?

[JieJenn]

For line Total2 = Cells(A + 1, 6).Value + Cells(A + 1, 7).Value, Excel does not recognize empty cell as 0. (5 + blank = error)

[Blue_kul]

Please Login or Register  to view this content.

.....has done job for me ... thanks !!!