I have a VBA macro that copies a table from MS Excel and pastes the contents into MS Word using bookmarks. The size of the table length varies greatly and sometimes takes up multiple pages.
Is there a way to get VBA to automatically 'break' the table whenever it should roll over onto a new page? Currently, the entire table resides on one page so much of the content doesn't fit and ends up getting effectively hidden.
Lastrow = ActiveCell.Row
table_range = "A1" & ":" & "D" & Lastrow
Set rng = wrdApp.ActiveDocument.Bookmarks("Chart").Range
Set tbl = rng.Tables(1)
.RelativeHorizontalPosition = wdRelativeHorizontalPositionMargin
.HorizontalPosition = wdTableCenter