Thanks Greg, that works well, but I was hoping for more of a fix on what I had out together.

The code I wrote made is more like a picture being pasted onto the word document, which is what I required. The code that you have written is more like a copy and paste, which means that the range selected will go over two pages. Also, I can set the page set up in Excel for it to fit on one page, but using your code the far right hand side is cut off- it falls off the end and needs resizing.

Essentially I need to why the code I wrote didn't copy the entire range.

Alternatively, how can edit the code you have written to make the range fit onto one page?

Any help?

Thanks,
Pete