VBA Dates/Times - getting midnight???

[combatvolcano]

I have tried several ways of doing this...

I have a cell on the "settings" sheet which is a date time formatted as the *standard mm/dd/yyyy

I have tried either dim'ing my variable dd as date or not and assign it using

dd = sheets("settings").Range("b2").Value

I am trying to compare this to another date/time

When I use a msgbox to look at the other date/time I see a valid date/time in the msgbox (even when using DateValue() on it)

If I do the same thing to "dd" I get " 12:00:00 AM"

It seems this is actually the value because if I try DateDiff I get a huge -number????

Even this doesn't seem to work!

    ddy = Year(Sheets("SETTINGS").Range("B2").Value)
    ddm = Month(Sheets("SETTINGS").Range("B2").Value)
    ddd = Day(Sheets("SETTINGS").Range("B2").Value)
    dd = DateSerial(ddy, ddm, ddd)
    MsgBox (dd)

I am confused, I just want to compare two date/times in VBA to if one is greater! (and delete the row if it is lesser but I have a handle on that part)

thank you!

 

[combatvolcano]

finally solved thanks for the assistance

 

[Norie]

Which cell is it?

In your first few posts it was B2, then it changed to C2.

In your loop code what is ActiveCell?