Autosize Row Height VBA Macro

[lawi227]

I have a worksheet called "Selected LP List" and on that worksheet, there are index(match()) functions in columns A:F that returns text linked to another worksheet. The problem I am having is that the rows do not automatically adjust the height so any wrapped text is cut off. Typically, column F will have the most text. In columns G:N, I manually enter notes and comments into those columns. There may be times when column G has the most text.

I need the macro to by dynamic because 1) the column with the most text is not always the same, and 2) the number of rows that returns text changes based on my selection. Note: the index match formula runs from row 4:740.

Thanks in advance!

 

[lawi227]

Bump. Any help on this?

I have found similar posts but none of the codes have worked.

Range("A" & row & ":F" & row).EntireRow.AutoFit
Range("F4:C" & lngLastRow + 10).Rows.AutoFit

I have a worksheet called "Selected LP List" and on that worksheet, there are index(match()) functions in columns A:F that returns text linked to another worksheet. The problem I am having is that the rows do not automatically adjust the height so any wrapped text is cut off. Typically, column F will have the most text. In columns G:N, I manually enter notes and comments into those columns. There may be times when column G has the most text.

I need the macro to by dynamic because 1) the column with the most text is not always the same, and 2) the number of rows that returns text changes based on my selection. Note: the index match formula runs from row 4:740.

Thanks in advance!