View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Billyruben Billyruben is offline
external usenet poster
 
Posts: 13
Default Activesheet.Paste does OK manually between worksheets but not

Hey Simon

Sub Macro15()
'

' Macro recorded 11/28/2008 by Billy
'
ActiveSheet.Paste
Range("C4").Select
'
End Sub

While Running the Macro, it stops and I get a MS Visual Basic window
displaying:

Run-time error '1004':
Paste method of Worksheet class failed

"Simon Lloyd" wrote:


If the macro failed what was the error? what was the code you used to
perform the task? we need more than you gave to give you an answer!


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=34846