Save As
 

Hi gan
I am trying to save one sheet of a workbook to a new file. Currently I am using...
Sub SaveTestSheetSeparately(
Worksheets("test").Cop
ActiveWorkbook.SaveAs "test1.xls
End Su
I would like the file name to be the contents of cell B3. How do I need to modify the code
Thank
Gene