The value in the cell is 2008-11-29
Why then does this code return a false?
If I switch the cell reference to![]()
If ActiveSheet.Cells(6, 8).Value > Mid("16800EBHRxx21Nov08-001.JPG", 12, 7) Then ActiveSheet.Cells(11, 11) = "PPP" End If
It returns a True.![]()
Mid("16800EBHRxx29Nov08-001.JPG", 12, 7)
Is there a certian date format I can use that will be recognized as such by both the worksheet, and the VBA macro?
Bookmarks