| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rename worksheet tab as date not text
Hello
I copied the code below from a book and it only works with text. How can I make this work with a cell formatted as a date Private Sub Worksheet_SelectionChange(ByVal Target As Range) With ActiveSheet .Name = .Range("J1").Value '.text ??? End With End Sub This is what I have JI is a merged cell from Ji to L1- also this the formula in JI =Sep307!J1+IF(WEEKDAY(Sep307!J1+1)=7,3,4) Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can't rename worksheet | Excel Discussion (Misc queries) | |||
| Using information from one worksheet, to rename inserted worksheet | Excel Worksheet Functions | |||
| why can't I rename my worksheet? | Excel Discussion (Misc queries) | |||
| Rename the worksheet | Excel Discussion (Misc queries) | |||
| rename worksheet | Excel Discussion (Misc queries) | |||
Threaded Mode
