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
|