View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_3_] Bob Phillips[_3_] is offline
external usenet poster
 
Posts: 2,420
Default creating new workbook from one sheet

Worksheets("Sheet2").Copy

--
__________________________________
HTH

Bob

"Dan" wrote in message
...
Hi,
I would like to create a new xls file made of the content of ny current
Sheet2 (not sheet1 or 3).
is it possible?
Many thanks,
Dan