Overflow error - same code, different sheet

I found that I get the overflow error because of the M2 = P3. When I
changed this and manually put in the date it works fine. Is there a
way to get around this?

I figured it out. I put in the first line of the code as range("m2") =
sheets(1).range("M2") and this solved the formula problem.