Posted to microsoft.public.excel.programming

external usenet poster

Posts: 1

copy method problem

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?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Why QUIT method doesn't work after COPY method?	surotkin	Excel Programming	3	October 26th 05 04:32 PM
Copy method failed	Daniel Bonallack	Excel Programming	2	October 14th 05 05:24 AM
Copy Method	Rowan[_2_]	Excel Programming	4	April 15th 05 08:48 AM
worksheet copy method	Marek	Excel Programming	1	September 6th 04 04:40 PM
Copy method fails in IIS	Domien	Excel Programming	0	February 19th 04 02:46 PM

All times are GMT +1. The time now is 04:18 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us