austenr
09-03-2010, 08:01 AM
I am having an issue where a certain date field in Excel sheet will not compare properly when checked in VBA.
I am only using a simple IF statement i.e.
If Sheets("Input + Wksheet").Range("D9").Value < "07/01/1996" Then
and the date keeps dropping in even when it IS greater than the criteria.
Can someone help me with the formatting mismatch from the Excel Sheet to the VBA code? Sample WB attached
I am only using a simple IF statement i.e.
If Sheets("Input + Wksheet").Range("D9").Value < "07/01/1996" Then
and the date keeps dropping in even when it IS greater than the criteria.
Can someone help me with the formatting mismatch from the Excel Sheet to the VBA code? Sample WB attached