Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-17-2024, 09:05 AM
Italophile Italophile is offline Height of all rows of all tables set as "at least". Windows 11 Height of all rows of all tables set as "at least". Office 2021
Expert
 
Join Date: Mar 2022
Posts: 555
Italophile is just really niceItalophile is just really niceItalophile is just really niceItalophile is just really nice
Default

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
Reply With Quote
  #2  
Old 03-17-2024, 09:35 AM
woocash_11 woocash_11 is offline Height of all rows of all tables set as "at least". Windows 11 Height of all rows of all tables set as "at least". Office 2021
Novice
Height of all rows of all tables set as "at least".
 
Join Date: Mar 2024
Posts: 4
woocash_11 is on a distinguished road
Default

Quote:
Originally Posted by Italophile View Post
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
You know, the problem is I am OCR specialist and my software always defines table row height as "exactly". These heights vary depending on the table and I can't define the minimum height.

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
Reply With Quote
  #3  
Old 03-18-2024, 03:05 AM
Italophile Italophile is offline Height of all rows of all tables set as "at least". Windows 11 Height of all rows of all tables set as "at least". Office 2021
Expert
 
Join Date: Mar 2022
Posts: 555
Italophile is just really niceItalophile is just really niceItalophile is just really niceItalophile is just really nice
Default

Quote:
Originally Posted by woocash_11 View Post
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
It is possible via VBA code, but you need to answer the same question as in the UI - at least what?

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.
Reply With Quote
Reply

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
Height of all rows of all tables set as "at least". 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
Height of all rows of all tables set as "at least". Macro to delete all rows with the word "Total" RandWald Excel Programming 4 11-28-2016 07:50 PM
Height of all rows of all tables set as "at least". Word Macro to find and delete rows that contain adjacent cells containing "." AlexanderJohnWilley Word VBA 7 11-08-2012 10:15 AM
Height of all rows of all tables set as "at least". How to choose a "List" for certain "Heading" from "Modify" tool? Jamal NUMAN Word 2 07-03-2011 03:11 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:36 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft