I am working on a macro that has three parts:
Part 1: Combine text in an existing xl sheet.
Part 2: Copy a column
Part 3: Paste the copied cells in word as text.
There are some issues with the second and third part.
The second part copies the text in a range of cell. Given my almost non existent VBA skills, I am copying a specified range. However, the ideal situation would be when the macro identifies that there is text in the cell and selects and copies the column.
The third part is supposed to paste the copied cells as text in a new word document. However, there are following issues:
1. The cells are pasting as table. However, I want them to paste as text in the word document.
2. The word document closes automatically. Is there a way for it to stay open?
Please see the attached sheet!!
I would very much appreciate if someone can help me fix this.
Thanks,
H
Bookmarks