i have a table with 10 rows. i have incorporated another table below that with one row. For some selection the second table disappears and that creates a void space below the first table. to remove that void space i want to adjust the height of the rows in first table such that it occupies the void space left.
Try this code,It will increase the cell height.
set TB = ActiveDocument.GetSheetObject("TB01")
box.Layout.MultiLine = 2
Hope it helps you...
set TB = ActiveDocument.GetSheetObject("TB03")
set vRows = ActiveDocument.GetVariable("vRowHeight")
box.Layout.MultiLine = vRows
This is not working. how do I pass the variable to the box.layout.multline setting?