View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
lunar1085[_2_] lunar1085[_2_] is offline
external usenet poster
 
Posts: 1
Default Working with Macros - ActiveSheet.Paste


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
+-------------------------------------------------------------------

--
lunar108
-----------------------------------------------------------------------
lunar1085's Profile: http://www.excelforum.com/member.php...fo&userid=3063
View this thread: http://www.excelforum.com/showthread.php?threadid=50817