Month Name

**Jarrettm** · 12-12-2014, 04:05 PM

Hi I am trying to get the month Name (EX. Today is 12-Dec-!4. So i would like it to put" December" in the cell). I Have the number currently being used with

Range("F17").Value = Month(Date)

**mehmetcik** · 12-12-2014, 04:07 PM

try


Sub macro()
For Count = 1 To 12
Range("A" & Count).Value = MonthName(Count)
Next
End Sub

**Jarrettm** · 12-12-2014, 04:15 PM

when i use this it puts January instead of the current month

**Jarrettm** · 12-12-2014, 04:21 PM

I am a little confused on where to insert this

**shg** · 12-12-2014, 04:20 PM

Range("F17").Value = Format(Date, "mmmm")

or

With Range("F17")
  .Value = Date
  .NumberFormat = "mmmm"
End With

**Jarrettm** · 12-12-2014, 04:24 PM

Originally Posted by shg

Range("F17").Value = Format(Date, "mmmm")

or

With Range("F17")
  .Value = Date
  .NumberFormat = "mmmm"
End With

thank you this worked

**shg** · 12-12-2014, 04:23 PM

It replaces the only code you posted.

**shg** · 12-12-2014, 04:37 PM

You're welcome.

Month Name

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Month Name

Re: Month Name

Re: Month Name

Re: Month Name

Re: Month Name

Re: Month Name

Re: Month Name

Re: Month Name

Thread Information

Users Browsing this Thread

Similar Threads

Caclulate month of quarter (1st month - 3rd month)

[SOLVED] Determine work days in current month or next month based on day of the month

[SOLVED] Counting & summing formula (until last month,this month,until this month..

[SOLVED] Auto instert Month names for This month, Last month and Next month

Moving average yearly, 6 month, 3 month, 1 monthand gives comparison using line graphs

Bookmarks

Bookmarks

Posting Permissions