View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
John Keith John Keith is offline
external usenet poster
 
Posts: 172
Default Confirm SaveAs takes place.

On Wed, 15 Oct 2008 16:30:44 +0200, "Ron de Bruin"
wrote:

Oops(I press the send button to fast)

If you want to save a few sheets to a new workbook you can use this to copy them to a new workbook

Sheets(Array("Sheet1", "Sheet3")).Copy


Thank you Ron, I think that will work great.



John Keith