Excel for Mac vs PC - Insert table at end of Word document

[lexxie2013]

Hi all,

I've built a workbook that creates a word document and inserts a table at the end. Works great on PC. When moved to a Mac, it puts the table at the start of the document rather than the end.

Has anyone experienced similar, and if so, did you find a workaround ?

The code, which appears to be ignored by the Mac is :

<code>
Set myRange = objDoc.Content
myRange.Collapse Direction:=wdCollapseEnd
Set TableNew = objDoc.Tables.Add(myRange, ProdCount + BlankProducts, 3)
</code>

Any comments would be greatly appreciated.
Thanks.