Richard's solution is testing the original and the inserted
rows in Column C. Since the inserted rows do not have
a value it works but it would be much better to
use to use Step -1 and start from the bottom and work
up. Checking inserted rows is not the most efficient.
And the test for numeric that he questioned if it would be
needed.
--
David McRitchie