Solus, thank you for that, however it doesn't solve my issue.

Actually the macro stops at 
 If Cells(i, 6) <> "Updated" Then
line when it sees that Erorr 2015 in the cell, but cell actually doesn't show any VALUE error, it shows "No updates".

And I run this code on several sheets, having the same format and same functions in all of them and it stops only on two of the sheets, others go nicely.
I tried to delete those sheets and do them again, same result.

I have no idea what goes wrong here.

Thank you for helping