Thanks so much to the 3 of you for your suggestions. I chose Leith's
because of its simplicity.

Roger

"Roger" wrote in message
...
I used "Do Until activecell = 0" in my prior Excel program but it doesn't
work in Excel 2002. Any suggestions? I would like a solution that solves
for blank rather than zero.

Thanks,

Roger