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.
I appreciate your help
+-------------------------------------------------------------------+
|Filename: Sub MainSubDue.doc |
|Download:
http://www.excelforum.com/attachment.php?postid=4310 |
+-------------------------------------------------------------------+
--
lunar1085
------------------------------------------------------------------------
lunar1085's Profile:
http://www.excelforum.com/member.php...o&userid=30639
View this thread:
http://www.excelforum.com/showthread...hreadid=508166