For some odd reason this code works in one workbook but not in another. Any idea what might be causing this? The error I receive is:

Compile Error:

Wrong number of arguments or invalid property assignment.


I am baffled because it works in some cases but not in all. Here is the code:

CurrDate = format(Date, "mm-dd-yy")