Working with Macros - ActiveSheet.Paste

[lunar1085]

I wrote a macros that copies data from a worksheet, creates a new worksheet, assigns a name to it and pastes the copied data, but now is 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' of Object '_worksheet failed'
What is strange is that it was running right then started failing.
can you help?

I appreciate your help

[Crowbar via OfficeKB.com]

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

--
Message posted via http://www.officekb.com