....snip...

That would certainly work but I was hoping to be able to avoid VBA loops if
possible as I find them generally slow. My problem is slightly simpler than
your general solution in that I know that:

1. I know the rows affected
2. All rows have data
3. All rows with identical data will be adjacent.

Currently I use a loop which keeps walking the rows whilst the row data
equals that in the first row (and then logically move the first row forward
when I find a mismatch) but I was hoping there was a more elegant solution.

Paul DS