View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rock* Rock* is offline
external usenet poster
 
Posts: 7
Default VB Method to copy and save only one sheet of the active workbook

How can I copy and save only one sheet of the active workbook.

This method copies the whole workbook and I only need to copy and save one
of the sheets:
ActiveWorkbook.SaveCopyAs

Thank you.
Diana