I am pasting to the same sheet more than 500 times. The code that I am
using is:

Range("A9:FY17").Select
Selection.Copy
curr = 9 * (i + 1)
Range("A" & curr).Select
Range("A" & curr) = i + 1
ActiveSheet.Paste
Application.CutCopyMode = False
Call ClearClipboard


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