VBA- Export from access to excel, autofit rows

[Leo_Polla_Psemata]

Hi
When we extract from access a report to excel (see my previous topic https://www.access-programmers.co.uk/forums/threads/extract-excel-from-access.324274/#post-1838727)
we can format various fields

When we want to fix the width of a column we have
.Columns("A:A").EntireColumn.AutoFit

How could we autofit an row ?

 

[theDBguy]

Have you tried?

.Rows(5).Autofit

 

[Leo_Polla_Psemata]

Have you tried?

.Rows(5).Autofit

Yes I have, it auto this fits the row as per the height of the 1st cell, e.g. e5 , not as per the tallest which might be the b5 or c5

 

[Gasman]

Yes I have, it auto this fits the row as per the height of the 1st cell, e.g. e5 , not as per the tallest which might be the b5 or c5

So find out the largest and then resize row to the largest?

Perhaps if you select the largest cell as the target, then the EntireRow will work?, else resize the range?

VBA AutoFit (Rows, Column, or the Entire Worksheet)

this tutorial shows you how to use VBA to apply auto fit to a column(s), row(s), entire worksheet, and also to the used range.

excelchamps.com

 

[Leo_Polla_Psemata]

So find out the largest and then resize row to the largest?

Perhaps if you select the largest cell as the target, then the EntireRow will work?, else resize the range?

VBA AutoFit (Rows, Column, or the Entire Worksheet)

this tutorial shows you how to use VBA to apply auto fit to a column(s), row(s), entire worksheet, and also to the used range.

excelchamps.com

Unfortunately, the height of three ceslls (c2, d2, e2, ) outlines company name address and contact person as well as telephones emails
These are b/lading parts so, c2 is Shipper, d2 Consignee and e2 notify party and are never the same size
One BL might have as shipper, a company with very long name and complicated address telephones, you would need need size 120 while
the next bl would need size just 40.
The same happens on consignee and notify fields.