I have tried recording a macro that would copy and paste a section of cells into a word document. The problem I run into is when I run the macro it follows all steps that took place in excel, yet it never does anything with the word document. When I read the macro code no reference is made to the word document. Here is what I am trying to do in step by step.
In Excel
Select U1:X1
Shift control down arrow
right click, copy
In Word
key shortcut to end of document
Paste, use destination style
Type "first word"
In Excel
right click, Copy R1
In Word
Paste, merge formatting, this is done to the right of "first word"
Type "second word"
In Excel
Right click, Copy R2
In Word
Paste, merge formatting, this is done to the right of "second word"
Any advice?
Bookmarks