louisli_evo
New Member
- Joined
- Mar 11, 2020
- Messages
- 11
- Office Version
- 365
- Platform
- Windows
Hi All,
I have a table that I need help on making a VBA/macro to adjust row heights on top of autofit-ting, autofit is good but it's too tight in viewing.
Mechanism:
I have a few columns of multi-row texts (B, D, and E), I need to:
- upon content change of that row, for example, I updated row 13 and by the time I hit enter or tab, it should start adjusting.
-- alternatively, I think I can run the VBA on demand, which I think it should be easier
- Range: row 2 to row 309
- if this row contains merged cells, skip to next row
- determine which column (B, D or E) on this row has the most lines
- add 25 pixels to the autofitted height
Could anyone shed some light on this issue? Thank you very much.
I have a table that I need help on making a VBA/macro to adjust row heights on top of autofit-ting, autofit is good but it's too tight in viewing.
Mechanism:
I have a few columns of multi-row texts (B, D, and E), I need to:
- upon content change of that row, for example, I updated row 13 and by the time I hit enter or tab, it should start adjusting.
-- alternatively, I think I can run the VBA on demand, which I think it should be easier
- Range: row 2 to row 309
- if this row contains merged cells, skip to next row
- determine which column (B, D or E) on this row has the most lines
- add 25 pixels to the autofitted height
Could anyone shed some light on this issue? Thank you very much.