I've strange problem with copy method in Excel 2003.



Sub Macro1()

Sheets("sht1").Select
Sheets("sht1").Copy After:=Sheets(3)



End Sub



When I run this code, it stop on copy method and unexpectedly break
application. Of course macro didn't duplicate "sht1".



Can anyone give me some help?

Is there anything interesting with Sht1? Does it exist? Is it hidden?

Do you have at least 3 sheets in that workbook?

If those don't help, what does the error message say?

beezak wrote:

I've strange problem with copy method in Excel 2003.

Sub Macro1()

Sheets("sht1").Select
Sheets("sht1").Copy After:=Sheets(3)

End Sub

When I run this code, it stop on copy method and unexpectedly break
application. Of course macro didn't duplicate "sht1".

Can anyone give me some help?

--

Dave Peterson