Help with do until loops.

Please Login or Register  to view this content.

d = InputBox("Enter the" & " from " & "date (m/d/yyyy)", , Format(Now(), "m/d/yyyy")) - Start Date
d2 = InputBox("Enter the" & " to " & "date (m/d/yyyy)", , Format(Now(), "m/d/yyyy")) - End date

What I want to happen is it will run the loop until the cell is empty and after checking all the rows, it will start the loop again with a different value of d.

example, first run... it will check all the rows. the value of d = 3/1/2013 after that, it will check all the rows again and the value of d will be 3/2/2013 and so on...

suggest using

Please Login or Register  to view this content.

is it really wend?

of course in vb it is wend

I see. Thanks.

=======================================
d = 5
d = 20

a = 4
Do Until IsEmpty(Worksheets("TDB").Cells(a, 8))

Worksheets("TDB").Cells(a, 8).Value + d

a = a+1
loop
=======================================
let us say I have 100 rows. I need to check those 100 rows first before I change the value of d. How can I achieve this?

so after 100 rows, d = 6
after 100 rows, d = 7 and so on...

Please Login or Register  to view this content.