Copy and paste/retain destination table formatting

[FJ]

Hi, I’m a VBA novice and I have what might be a very simple problem, but I’m
stumped. Basically, what I want to do is be able to highlight a range of
cells in a table, click into another preformatted table, and paste the data.
However, when the data is pasted into this preformatted table, I want the
data to retain the destination formatting, NOT the source formatting. I
thought I could use something like the following:

Selection.Range.PasteSpecial DataType:=wdPasteText

but even though that does retain the destination table’s styles and
formatting, everything ends up all in one cell, which is not what I want. Is
this something that would be incredibly complicated to do with VBA? Or am I
just missing something obvious?

Thanks in advance for any help.

 

[FJ]

Hi, nevermind. I figured it out.