how to loop between two dates which moves every hour.

hello,
can u guys, please give me vba code to compare 2 thing between 2 dates & it should check with loop at every 1 hours time lapse between those 2 dates.

for example, I would like to compare A, B, C between date 2/20/12 to 2/22/12. It should check 2/20/12 0:00, then 2/20/12 1:00 then 2/20/21 2:00 then so on, upto 2/22/12 23:00.

In this case nothing is specified abt input A B C. let them get matched everytime. A=B=C i would like to get it print with date & time stamp as result on same sheet at bottom. In this case it may print it 48 times.

Thanks in advance

hello, can u guys, please tell me vba code to compare A B C between 2 dates & it should compare A B C at every 1 hours time interval between those 2 dates.

for example, I would like to compare A, B, C between date 2/20/12 to 2/22/12. It should check 2/20/12 0:00, then 2/20/12 1:00 then 2/20/21 2:00 then so on, upto 2/22/12 23:00.

In this case nothing is specified abt input A B C. let them get matched everytime. A=B=C i would like to get it print with date & time stamp as result on same sheet at bottom. In this case it may print it 48 times.

Thanks in advance

Check out OnTime in VBA Help.

Quote:

---

Originally Posted by mdmackillop

Check out OnTime in VBA Help.

---

Thank you.