LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Paste method fails in VBA


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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
select method of range class fails mark kubicki Excel Programming 12 April 27th 05 02:37 PM
Chart location method fails using sheet name deko[_2_] Excel Programming 3 March 4th 05 02:54 PM
Workbooks.open method fails JAT Excel Programming 3 January 24th 05 08:19 PM
Select method of Range fails J West Excel Programming 1 June 7th 04 02:41 PM
Copy method fails in IIS Domien Excel Programming 0 February 19th 04 02:46 PM


All times are GMT +1. The time now is 12:37 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"