Many thanks for the response Dave, much appreciated.

Unfortunately, the tables sometimes span many pages, thus this would not work. As i said, it is a the orientation that appears to be the issue, further head scratching and testing yesterday. I had originally had an issue with the image only pasting half the columns, resolved by adding "tbl.PreferredWidth = 0"

Removing this line yesterday, led to all rows being displayed, but back to only half of the columns again

more trawling of internet today, i feel, for the nugget of info i require.

Thanks or your help once again