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.)
Bookmarks