Thread: code works in excel 2002, but not in excel 2003
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JE McGimpsey JE McGimpsey is offline
external usenet poster
  
Posts: 4,624
Default code works in excel 2002, but not in excel 2003
Works for me in both XL03 and XL04.

Are you sure the cell contains what you posted?


In article ,
pyc wrote:

Cells(j, 1) = DateValue(Cells(j, 1)) + TimeValue(Cells(j, 1))

this is the line, and the error message is "type mismatch" ... same
code works in excel 2002, but not in 2003.

The date is in format: 01-Dec-02 10:18:59 AM


please help.... it must be a classic problem...
Reply With QuoteReply With Quote