I guess the following line causes the issue.
That is because, for one instance, one value comes
decimal
and other comes as
dbnull
.
Insert.Parameters(1).Value = (Row.Cells(favcadr.Index).Value - Row.Cells(favcacr.Index).Value)
So, debug your code and find out what is the issue. Then correct your code.