That works, thank you so very much, you have solved a problem for me and given me a macro to study for further use. Well done.

I did notice that the page number at the bottom doesn't update, it stays the same throughout. Is there an easy fix for this?