![]() |
|
#1
|
|||
|
|||
![]()
Unless the height of the rows has already been set to "At Least", or "Exactly", there is no way to determine the current height of the row. Querying the row height in VBA will return a value of "Undefined".
You will need to decide what the minimum height should be, then modify the code in post #2 to set the Height property |
#2
|
|||
|
|||
![]() Quote:
In my work computer there were the script on the outside platform that was doing this without any problems, so I thought it might be possible via VBA code. Apparently I was wrong ![]() |
#3
|
|||
|
|||
![]() Quote:
This is a decision that is usually taken at the time of designing the document, not applied after the fact when you already have tables with content and merged cells. |
![]() |
Tags |
height, table rows, vba |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Excel 2003: VBA "Function" causes "#VALUE!" errors after running "insert/delete row" custom macro | Matt C | Excel Programming | 2 | 01-08-2022 06:03 AM |
![]() |
Tsavard | Word | 2 | 06-11-2018 09:08 AM |
![]() |
RandWald | Excel Programming | 4 | 11-28-2016 07:50 PM |
![]() |
AlexanderJohnWilley | Word VBA | 7 | 11-08-2012 10:15 AM |
![]() |
Jamal NUMAN | Word | 2 | 07-03-2011 03:11 AM |