RE: Problem with finding dates in Excel Macro

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: sebastienm (sebastienm_at_discussions.microsoft.com)
Date: 07/17/04 

Date: Sat, 17 Jul 2004 11:11:02 -0700

-What about
   = (VALOR(faxdata!A290)=VALOR(07!B7) )
    B7 or the one containing the 10/07/2004 in *** 07
   By the way, does it contain the year in yyyy format or in yy format?
   What does the function returns? TRUE or FALSE ?

- another thing to try:
   Set c = .Find(Format(Data,"dd/mm/yyyy"), LookIn:=xlValues)
   or "dd/mm/yy" depending if the *** shows 2004 or 04 as year.
   This forces to match a String, not a date.

Hopefully we'll be more lucky today :-)
Seb
    

-- 
Regards,
Sébastien
"Ped_Esc" wrote:
> Yes you're right im using spanish version, so i changed to =valor(B7) and showed my a number with no decimals on both files.
> 
> 10/07/2004 begins at cell A290 then 18 rows down (A308) is 11/07/2004 and same with the rest except for dates wich has not only AM but PM.
>
Quantcast