Bob --
I meant that the column of dates may be ANY successive dates grouped
in sevens. Example

7/10/03
7/11/03
7/12/03
7/13/03
7/14/03
7/15/03
7/16/03
7/17/03 Then the dates repeat again like
7/10/03
7/11/03
7/12/03
7/13/03
7/14/03
7/15/03
7/16/03
7/17/03 then the dates repeat again down the coulmn for as long as
possible.

I need the code for a macro that will loop through the dates column and
ensure that for any group of repeated 7 dates no date is missing. If any
dates are missing in any block of seevn dates then the macro should
insert the equivalent number of rows and update the dates. E.g If it
finds that the date below say 7/11/03 for any group of seven days is
7/15/03, then it should insert 3 blank rows and update the dates column
so 7/11/03 is followed by 7/12/03, 7/13/03, 7/14/03 before the 7/15/03.
Thanks.

Jay



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!