Macro for increasing row height

[#1]

I want a macro for increasing row height of a table

.

I could not find that in the API Guide

[nilesh_gangurde]

Hi Sumit,

Can you elaborate the requirment.

What you want to do Actualy ??

Regards,

Nilesh Gangurde

[#3]

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.

[#4]

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

....

[#5]

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

[#6]

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?

[tamilarasu]

Hi Deborah,

Could you open a new thread for this issue. ?

[#8]

[#9]

This worked so I am good!  Thank you

[tamilarasu]

Glad the you found the solution.