Not sure what you mean by pasting back from an array. If it truly is
paste, you can use paste special:

Selection.PasteSpecial Paste:=xlPasteValues



--
kkkni
-----------------------------------------------------------------------
kkknie's Profile: http://www.excelforum.com/member.php...nfo&userid=754
View this thread: http://www.excelforum.com/showthread.php?threadid=26849