I have a workbook with multiple worksheets.
I would like to copy the contents of one worksheet into a word document.
There is normal text at the top of the worksheet, then a text box underneath,
containing more text.
I am trying to highlight the data to copy into word, but the text box is not
included in the selection, therefore the text box data is not copied.
Either
a) do I need to amend one of the text box properties so that the text box
can be selected and thus copied via copy/paste
b) is there a way of automating the transfer of this data into word, i.e.
can a button be added which when clicked, takes all the data, opens a word
document and pastes it as it appears in Excel?
Any help would be appreciated.
Thanks in advance.