![]() |
|
|
|
#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 |
|
|
Similar Threads
|
||||
| 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 |
Help get rid of weird default "lines" or "table" look in document that has no tables or lines
|
Tsavard | Word | 2 | 06-11-2018 09:08 AM |
Macro to delete all rows with the word "Total"
|
RandWald | Excel Programming | 4 | 11-28-2016 07:50 PM |
Word Macro to find and delete rows that contain adjacent cells containing "."
|
AlexanderJohnWilley | Word VBA | 7 | 11-08-2012 10:15 AM |
How to choose a "List" for certain "Heading" from "Modify" tool?
|
Jamal NUMAN | Word | 2 | 07-03-2011 03:11 AM |