Again, assuming that the number of errors is in cell A1
MsgBox ("You have " & Range("A1").Value & " errors on this page.")
Thanks that is exactly what I needed. Now for one more trick. I have a column that will have values changing but not in consecutive order. For example if I had range A1:A10, only A1, A4, and A9 would have values, but the rest of the cells would be blank. I need to be able to generate A1, A4, and A9 into the next column consecutively as B1, B2, and B3. The A column values could change (including the number of values) and I need the B column to react accordingly. So the next time I run the data, I could have A2, A3, A4, A6, and A10 with data in them- so I need column B to be able to react and put the values (in order) as B1, B2, B3, B4, and B5. Oh and I need all this done in a MsgBox. Can you help? Thanks so much.