The pb was due to a date which were in a bad format (not a format date)
and there were an format condition on this column. The conditiona
format called a macro to calculate difference between dates. As ther
were a bad date in one cell, instead of showing error when callin
xlPasteFormats , excel did nothing, waiting for user action (manual
paste) since it just called the copy function before.

Thats all..

--
itarna
-----------------------------------------------------------------------
itarnak's Profile: http://www.excelforum.com/member.php...fo&userid=2786
View this thread: http://www.excelforum.com/showthread.php?threadid=47372