naming a workbook the same as a cell entry

D

des-sa

is it possible to automatically name a workbook the same as a cell entry when
i instruct the program to save the file?
 
A

Adilson Soledade

If the name is, for example, at Range A1 in a Worksheet called Setup, you
could use this command:
ThisWorkbook.SaveAs (Worksheets("SetUp").Cells(1, 1).Value)
 
Top