Unless your data and/or the worksheet itself are different to what you posted, I can't see how that's possible. The macro was coded, tested and confirmed as working correctly with the worksheet you posted.



Finally, merely saying "This gave me some errors" without saying what they were robs yourself of any chance of getting the problem solved, so all you're left with is a 'workaround'.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]