Excel Macros in 2007

[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?

 

[Don Guillett]

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

 

[Jacob Skaria]

Please make sure the named range exist in the workbook..

 

[JLara-MSN-WI]

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.

 

[Don Guillett]

If desired, send your file to my address below along with this msg.

 

[Don Guillett]

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.

 

[Don Guillett]

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.