I cannot understand why the first line of code works fine but the second does not all I have changed is the 2 to a date.
Set c = Sheet1.Range("b2:ae2").Find(2, LookIn:=xlValues)
Set c = Sheet1.Range("b2:ae2").Find("09/08/2010", LookIn:=xlValues)
Thanks you for yo0ur help
Set c = Sheet1.Range("b2:ae2").Find(2, LookIn:=xlValues)
Set c = Sheet1.Range("b2:ae2").Find("09/08/2010", LookIn:=xlValues)
Thanks you for yo0ur help