View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Veronica Veronica is offline
external usenet poster
 
Posts: 19
Default Insert Current Date on a Sheet 1 Tab

That did it! Can't thank you all enough for your knowledge!!
Have a great day!
--
Veronica.


"Herbert Seidenberg" wrote:

Try
Sub NameShToday()
Dim td As Date
Dim d As Long
Dim e As Long
Dim m As String
Dim y As Long
td = Date
d = Day(td)
e = Month(td)
m = MonthName(e, 1)
y = Year(td)
Sheets("Sheet1").Name = _
m & "-" & d & "-" & y
End Sub