Hi Ian,

Am Mon, 29 Apr 2013 06:52:43 -0700 (PDT) schrieb pcorcele:

Thanks for all the help.I did try your suggestions......But I found out that I did not give you all the info required. Using your suggestions, copied the ENTURE file. My file consists of THREE sheets. I just want to copy the first sheet which is called MYMOVIES. I would appreciate any help with this
and thanks

change the line with copy to:
Sheets("MYMOVIES").Copy


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2