Dave and Insomniac,
Thanks so much for your responses - you have definitely lead me towards a solution.
In testing your solutions, I discovered another oddity - if your rows have no in-cell formulas, deleting a row still generates a change event, but inserting a row doesn't! Don't need a solution for this one.
Can one praise Microsoft enough?