help: I need to have an excel worksheet name = a cell in an existi
 

help: I need to have an excel worksheet name = a cell in an existing workbook.
the cell reference is a merged cell, and is a date

help: I need to have an excel worksheet name = a cell in an existi
 

Dim dt as Date
dt = Worksheets("Sheet1").Range("B9").Value
Activesheet.Name = format(dt,"yyyymmdd")

--
Regards,
Tom Ogilvy

"tim m" wrote:

help: I need to have an excel worksheet name = a cell in an existing workbook.
the cell reference is a merged cell, and is a date

help: I need to have an excel worksheet name = a cell in an ex
 

Where and how do I place this?

"Tom Ogilvy" wrote:

Dim dt as Date
dt = Worksheets("Sheet1").Range("B9").Value
Activesheet.Name = format(dt,"yyyymmdd")

--
Regards,
Tom Ogilvy

"tim m" wrote:

help: I need to have an excel worksheet name = a cell in an existing workbook.
the cell reference is a merged cell, and is a date