i think this topic has been repeated, but please help me sti

[LMF]

ok, i got a workbook with many sheets, what code do i need to save a single sheet onto a particular place??

pls let me know, thanks
This message was edited by LMF on 2002-04-16 05:13

 

[Al Chara]

Sheets("Sheet1").Copy

will copy sheet1 to a new workbook. Is that what you wanted?