buhay
09-22-2010, 01:19 PM
I use the following macro to display the text "at the end of september". How do I change it so that it displays last months name instead of the current month.
The text should be "at the end of august"
Selection.TypeText Text:="at the end of" & " " & Format(Now, "mmmm")
Thanks in advance
The text should be "at the end of august"
Selection.TypeText Text:="at the end of" & " " & Format(Now, "mmmm")
Thanks in advance