Hi, Francis. How do you want the spreadsheet range to show up in Word? As
a Word table? As a linked item, where clicking on it opens that workbook
for editing in Excel? Or as a graphic, un-editable representation of your
Excel table? One thing to keep in mind - the transition between the two
programs does not like merged cells very much, and will affect how a Word
table will look.

Ed

"Francis Hookham" wrote in message
...
I regularly copy a range from an XL spreadsheet into a Word document by
hand but I should like to automate this if possible

Initial recording selecting a range in spreadsheet, opening a blank Word
document and pasting did not show much promise

Any Suggestions?

Francis Hookham