| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell value as part of a worksheet ref. in Excel | Excel Discussion (Misc queries) | |||
| Excel, copying a cell from one worksheet to another | Excel Discussion (Misc queries) | |||
| How do I add a comma to every cell in my excel worksheet | Excel Discussion (Misc queries) | |||
| Is there anyway to hide #DIV/0! in an excel worksheet cell. | Excel Programming | |||
| How do I place an excel worksheet name in a cell? | Excel Worksheet Functions | |||
Linear Mode
