Macro for saving files where title is made from cell references
 

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

Macro for saving files where title is made from cell references
 

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