I have a workbook with 2 worksheets named WKO and Report. I am tryin
to write a macro to look at a cell containing a date in worksheet WK
and put the month's name in a cell on worksheet Report. The dat
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
=MonthName(Month(WKO!C3)

--
cbetmar
-----------------------------------------------------------------------
cbetmark's Profile: http://www.excelforum.com/member.php...fo&userid=2619
View this thread: http://www.excelforum.com/showthread.php?threadid=39500