Code Help for naming a worksheet tab
Sheets("DDS (2)").Name = Format(Now, "yyyy-mm-dd") & " " & Range("U2")
OR
Sheets("DDS (2)").Name = Format(Now, "yyyy-mm-dd_hh-mm-ss") & _
" " & Range("U2")
If this post helps click Yes
---------------
Jacob Skaria
"Very Basic User" wrote:
This code works fine with one exception. I only name the new tab with a date
and time stamp. In a cell "U2" the user selects shift too. What I would like
if for the code to read both the Date and the cell "U2" shift to name the new
tab. So end state I would see a tab named like this (01-01-2009 Shift 3) is
there any way to add that to this code. I hope this is enough information.
Thanks!
Sub SaveSheet()
SaveSheet Macro
Sheets("DDS").Select
Sheets("DDS").Copy Befo=Sheets(3)
Sheets("DDS (2)").Select
Cells.Select
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
:=False, Transpose:=False
Range("B1").Select
Application.CutCopyMode = False
Sheets("DDS (2)").Select
Sheets("DDS (2)").Name = Format(Now, "yyyy-mm-dd_hh-mm-ss")
Range("B1").Select
Sheets("DDS").Select
Range("B1").Select
End Sub
--
Thank you for your time!
John
--
Thank you for your time!
John
|