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

LMF · Apr 16th, 2002, 04:35 AM

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 · Apr 16th, 2002, 12:31 PM

Sheets("Sheet1").Copy

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

Apr 16th, 2002, 12:31 PM	#2
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	Sheets("Sheet1").Copy will copy sheet1 to a new workbook. Is that what you wanted? __________________ Kind regards, Al Chara

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 16th, 2002, 04:35 AM	#1
LMF Board Regular Join Date: Mar 2002 Posts: 73	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 ]