I am trying to paste some 10 rows containing formulas 500 times using
Selection.copy and ActiveSheet.paste.
The macro fails and throws up the error - "Run-time error '1004'. Paste
method of Worksheet class failed". (I clean the clipboard after each
paste.)


--
lalu
------------------------------------------------------------------------
lalu's Profile: http://www.excelforum.com/member.php...o&userid=28055
View this thread: http://www.excelforum.com/showthread...hreadid=475665