Solved: Need a msgbox to report to me the missing record number

[frank_m]

HI mancubus and simon

Even though they are numbers and the cells are formatted as numbers, I get a type mismatch error with both of your routines. - I tried prefixing all the values with Val(....value), and that avoids the error and gets results from mancubus code, except that the results are incorrect. - And with simons recommended change, I get no results.

simon, with your routine, as I said above, I was getting a type mismatch error, so I added Val(...Value) in the appropriate places. Now I get what looks to be every row listed in the msgbox(I'm not sure if you remembered, that my numbers get smaller from top to bottom.


I got out of my jam awhile before all of you posted, by using a formula similar to Pauls

Thank you all


I'll respond further tomorrow, as I'm too tired right now.