Guys,

This is a new one to me anyways. I was wondering if anyone could she
any light on it for me. This has to be the simplest piece of vb cod
ever, and it works in another workbook no questions asked!!???


Code
-------------------

Dim fmtDate As String

fmtDate = Format(Date, "mmm-yy")

-------------------


When I compile the code I get the if highlights *Format* and I get the
following error

Compile Error:
Wrong number of arguments or invalid property assignment

What the hell am I doing wrong? As I said, same version of exce
different workbook this works fine... as it should.

Thanks,
Lia

--
wjoc
-----------------------------------------------------------------------
wjoc1's Profile: http://www.excelforum.com/member.php...fo&userid=1528
View this thread: http://www.excelforum.com/showthread.php?threadid=47469