Macro for saving files where title is made from cell references

V

vikramsingh1970

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
 
M

Mike

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


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