Tricky - expanding rows problem

[Tenaciousjeebs]

Hi All,

I want to expand a row to accommodate a large number of text data in a certain cell i.e. make it visible. However, the kicker is that the specific cell I want to expand is not the largest cell in the row, and thus when I double click to expand, the row expands far beyond what I actually need it to.

Is there any way around this? Any help would be greatly appreciated.

Best,

Scott

[JieJenn]

Can you post your file?

[Tenaciousjeebs]

Hi,

I would like to expand row 1 based on the text length (not sure if that's the correct term) in cell B1, but it defaults to the length of I1. Any ideas?

Best,

Scott

[JieJenn]

The only way I can think of is using VBA on the Worksheet Event.

Please Login or Register  to view this content.