I have a named range in an Excel workbook and I'm pasting it into Word. The named range is a single cell but it was pasting in as a single cell Word table when I wanted it to paste as text. As I typed out my question it dawned on me that the problem was I was just using:
Code: Select all
Selection.Paste
Code: Select all
Selection.PasteSpecial DataType:=wdPasteText
Thanks for listening.
Ken