Hi, Im running a macro which updates then time in Range("a1"),
(Range("a1").Value = Time). The macro goes of does its job, updating
the time at set intervals, then when conditions are met, in
Range("a2") it adds the time now + 60 minutes. In vba I want to say if
time in a1 time in a2 then............ Ive tried simply if a1a2
then, sometimes it works, but not always. eg at the momment in a1 I
have 12:07 and in a2 11:04. vba says a2 is the greater. Is there a
better way to do this.
Regards Robert