Have you tried paste special and selecting formula?

Love Big Tim x


--
bigtim
------------------------------------------------------------------------
bigtim's Profile: http://www.excelforum.com/member.php...o&userid=23747
View this thread: http://www.excelforum.com/showthread...hreadid=374475