Bob

Sorry about the multiple posts - working on two different computers (work and home) and the search works differently when I look up the thread. I don't see everything, thus multiple postings. ??

Your mod works great - thanks. As to the first issue, eliminating blank lines: I ran this macro on a worksheet and the result was a lis of 523 rows, with all 523 rows showing the cell (or range) address in column A. However, only 88 of the rows showed a formula in column B and its corresponding return value in column C. What I would like to do is eliminate the rows where column B and C are blank

Phil