Hi,
I am developing a macro in which I add new sheets to a database every time I
export data to it. In order to recognize these sheets, I would like to be
able to make the name of the sheet equal to the contents of a cell in the
exported sheet. Currently, the code reads

Sheets("Sheet1").Select
Sheets("Sheet1").Name = "Name"

Is there anyway that I can make the "Name" - part into a dynamic
cell-reference?

Thanks
Zyvind