austenr
08-17-2010, 12:25 PM
Anyone see what would give me a "Object doesnt support this property or method" error:
If Sheets("Input + Wksheet").Age.Value < 65 And Sheets("Input + Wksheet").ColgagteHills.Value = "Colgate" _
And Sheets("Input + Wksheet").medcvg.Value = 1 And Sheets("Input + Wksheet").Range("D9").DateValue <= "7/1/1996" Then
MsgBox "Colgtate"
End If
If Sheets("Input + Wksheet").Age.Value < 65 And Sheets("Input + Wksheet").ColgagteHills.Value = "Colgate" _
And Sheets("Input + Wksheet").medcvg.Value = 1 And Sheets("Input + Wksheet").Range("D9").DateValue <= "7/1/1996" Then
MsgBox "Colgtate"
End If