Help with word page breaks

I am pretty new to vba but am getting the hang of access and excel quite well.

I am running an excel macro and trying to export ranged of cells to word. i can manage to format my title and paste in the fist table but after that i want to insert a page break and change to landscape.

I am struggling to select anything after the table.

here is my code (part of a much larger sheet)
dtable is a predefined range of cells from another macro

Please Login or Register  to view this content.

When I paste in my table, each cell becomes a paragraph. This normal?
How is the next paragraph after the table identified?


Thanks for any help

I know this is something to do with the collapse method but I can't get it to work

If I manually create a blank doc in word and add a table I am trying the following but it doesn't work

activedocument.tables(1).range.Collapse wdCollapseEnd
activedocument.tables(1).range.InsertBreak

the break happens above the table, not below it