2
Contributors
3
Replies
10
Views
4 Years
Discussion Span
Last Post by AndreRet
0

You would use something like -

Sub FormatNow()
    Dim myWorksheetName As String
    myWorksheetName = Format(Now, "mmmm_yyyy")
    MsgBox myWorksheetName
End Sub
0

Thanks, the code works perfectly well!

    Dim dateStr As String    
    dateStr = Format(Now, "ddmmyyyy")
This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.