Working with Macros - ActiveSheet.Paste

  • Thread starter Thread starter lunar1085
  • Start date Start date
L

lunar1085

I wrote a macros that copies data from a worksheet, creates a ne
worksheet, assigns a name to it and pastes the copied data, but now i
failing when pasting. It does paste 2 lines of data and then quits.
My macros is giving out an error Run-Time-error: Method 'Paste' o
Object '_worksheet failed'
What is strange is that it was running right then started failing.
can you help?

I appreciate your hel

+-------------------------------------------------------------------
|Filename: Sub MainSubDue.doc
|Download: http://www.excelforum.com/attachment.php?postid=4311
+-------------------------------------------------------------------
 
I to have resently had the same problem

I fixed it by inserting the command for each sheet it was going to to copy
andf then paste

May not work for you like but its worth a try
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Error 1004, paste method of Worksheet class failed 3
Run macro from active workbook whose name keeps changing 20
Running macros in Excel 2007 9
ActiveSheet.Paste Error 7
What is Error "Method "Paste" of object "_Worksheet" failed? 7
Don't want to hard-code file name in macro 3
Macro to copy A1 tp J(bottom) 1
Fixed and Relative Macro References 7

Back
Top