I'm using the following VBA statement as part of a routine to copy Sales Invoice info to another sheet in Excel 2003:

Sheets("Unpaid").Cells(UnpaidRow, 11).Value = _
Sheets(2).Cells(SalesRow, 49).Value

The value being copied to Sheet(2) is a date.

The statement works fine providing the date being copied is less or equal to the current date. If the date is in advance of the current date then I get "Error 13 - type mismatch"

I've no idea why this doesn't work as the cells in question both contain valid date values.

Any help would be welcome.