Dear All,

I'm trying to copy some text from a cell in one table, to a cell in another table above the current text, while preserving the formatting. I don't want to use the clipboard as I don't want to disturb it.

Anyway, the code I have right now is as follows:
Dim OriginalText As Range
Dim InsertText As Range

To get the formatted text from a cell I'm using this code:
Set OriginalText = SourceTable.Cell(RowNum, ColNum).Range

To insert the formatted text I'm using this code:
Set InsertText = DestinationTable.Cell(RowNum, ColNum).Range
With InsertText
    .Collapse Direction:=wdCollapseStart
    .FormattedText = OriginalText.FormattedText
End With

Instead of inserting the formatted text in the cell before the current text, it simply blanks out the whole row!!! Very bizzare! If I write the formatted text to, say, the beginning of the Active Document, it comes out fine (albeit with an unprintable character following though).

Does anyone have any ideas where I'm going wrong, or what I need to be doing instead?

Cheers,
Nick