what is the value in M2 when you get the error?

rgard

--
tony
-----------------------------------------------------------------------
tony h's Profile: http://www.excelforum.com/member.php...fo&userid=2107
View this thread: http://www.excelforum.com/showthread.php?threadid=52783

M2 is the year, currently 2007, and the code on sheet 1 will run when
this is changed.

I think I should also note that on every subsequent sheet, M2 = P3
which is =DATE(Jan!M2,1+1,1)+TIME(20,0,0) and the month is edited
appropriately for each sheet.

On the first sheet, M2 is the year, currently 2007. On every
subsequent sheet, M2 = P3 (format "yyyy") which is
=DATE(Jan!M2,1+1,1)+TIME(20,0,0) and the month is edited appropriately
for each 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.