I would like to add one month to a date in a cell overwriting it wit
the new date. For example Cell A1 has the date 9/1/2004 and when m
macro is run A1 becomes 10/1/2004.

I can easily do this with the DATE(Year(a1),Month(a1)+1,day(a1) in
cell but I need to run it from the macro and overwrite the existin
cell.

Any help is appreciated

--
bugg
-----------------------------------------------------------------------
buggy's Profile: http://www.excelforum.com/member.php...fo&userid=1666
View this thread: http://www.excelforum.com/showthread.php?threadid=31882