Problem Solved

I have solved the error in those macros, as it turns out, there was spaces in the cells. Therefore, the computer couldn't add 1 which caused the error. I simply backspaced in the cells and then it suddenly worked. Sometimes, problems can be solved with the simplest solutions i.e simply backspacing :)