Excel Macros in 2007

  • Thread starter Thread starter JLara-MSN-WI
  • Start date Start date
J

JLara-MSN-WI

In Excel 2003, my macro runs ok, but in Excel 2007 got the message:
Run Time error '1004':
Paste method of workshett class failed

This happens when the macro runs at:
Application.Goto Reference:="Mes_DosOnce"
ActiveSheet.Paste

My workaround is to run the macro in an Excel 2003 instance, but i need to
copy the file between pc's.

How this issue Can be solved?
 
Must be some other problem. I just tested this in 2003 and 2007. No problem

Sub gothere()
Range("a2").Copy
Application.Goto "msss"
ActiveSheet.Paste
End Sub
 
Thanks for your response Don.
The name exists, because I open the file in Excel 2003, run the same macro,
and runs ok, but in Excel 2007 got the message.
 
I looked at this file and can find no reason why it doesn't work, but it
doesn't. Corrupt file???????
You can actually record doing it manually but when trying the recorded code,
it fails.Wierd!!
I even tried range("g8").copy range("f8") with no luck.
 
I looked at this file and can find no reason why it doesn't work, but it
doesn't. Corrupt file???????
You can actually record doing it manually but when trying the recorded code,
it fails.Weird!!
I even tried range("g8").copy range("f8") with no luck.
 
Back
Top