Adjusting row heights on top of autofit

[louisli_evo]

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.

 

[Fluff]

I can see 3 replies to your posts so far (4 with this one)

And that doesn't include my post on the duplicate thread (now locked), where I also said it can't be done.