Hi Dave..

Thanks for your help. But it is creating a new worksheet. I want to
copy the content in the exesting worksheet only, after the existing
content. I dont want to add new worksheet. How to do that?

I tried newwkbk.Worksheets(1).Copy Destination:=CurWks

But its not working. :(

Can you please help me for this?

Thanks,
Sylvia


--
Sylvia
------------------------------------------------------------------------
Sylvia's Profile: http://www.excelforum.com/member.php...o&userid=30300
View this thread: http://www.excelforum.com/showthread...hreadid=500573