I have a workbook with 2 worksheets named WKO and Report. I am trying to write a macro to look at a cell containing a date in worksheet WKO and put the month's name in a cell on worksheet Report. The date format of the cell is 2005/07/05. Here is my code.

Sub
Dim j as String

j = MonthName(Month(WKO!C3))

Range("A1").Select
ActiveCell.Formula = "j"

End Sub

I get a 424 Runtime Error - No Object Defined for the line j =MonthName(Month(WKO!C3))