copy method problem

  • Thread starter Thread starter beezak
  • Start date Start date
B

beezak

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top