looping issues

Thanks Mikerikson - I recall reading in one of the moderator's postings that setting ranges in general is a bad idea. Given that, and taking your reply into account, I'm beginning to think a better approach would be to use a Do Until IsEmpty routine together with the offset you mentioned to specify which cells to use in calculating the next service date.

Is that a better approach? Any advice you can offer is appreciated. Thanks again - Marcus