will save to desktop with the value of cell A1
Sub SaveAs()


ActiveWorkbook.SaveAs Filename:=Range("A1").Value & ".xls"
End Sub

" wrote:

Hi,

I was wondering how you would create a macro that saves the file as
with a title made from cell references in the sheet.

Kindest Regards,

Juliodenero