Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want a macro for increasing row height of a table
.
I could not find that in the API Guide
Hi Sumit,
Can you elaborate the requirment.
What you want to do Actualy ??
Regards,
Nilesh Gangurde
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.
Hi
Try this code,It will increase the cell height.
Sub Height
set TB = ActiveDocument.GetSheetObject("TB01")
set box=TB.GetProperties
box.Layout.MultiLine = 2
TB.SetProperties box
End Sub
Hope it helps you...
Regards
....
can you use a variable in place of the 2 in the multiline properties? I tried a few ways but not working. What is syntax if possible, for using variable in macro
Sub Height
set TB = ActiveDocument.GetSheetObject("TB03")
set box=TB.GetProperties
set vRows = ActiveDocument.GetVariable("vRowHeight")
box.Layout.MultiLine = vRows
TB.SetProperties box
End Sub
This is not working. how do I pass the variable to the box.layout.multline setting?
Hi Deborah,
Could you open a new thread for this issue. ?
This worked so I am good! Thank you
Glad the you found the solution.