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