Hi Macropod
Your code works perfectly!
Just one more small thing although.
I amended it a little bit to fit my purpose better, I added a userform to obtain the reference information from the user.

then store the starting reference numerical number in variable: Myref
say the user input 100
myref = 100

and i would like to reference the first page as 100, the next one is 101... etc

however currently the code is using the page number only.

Could you please advise how to amend this?

Thanks a mill