vba to detect if column contains partially hidden text

[Guest]

Is it possible using vba to detect if data in a cell column is not being
completely displayed? The idea is to then use autofit on that column.

tia,
dk

 

[Otto Moehrbach]

Why not just use autofit and be done with it? If there is not data that is
not displayed, the column width will not increase. If there is, it will
HTH Otto

 

[Guest]

Only interested in scenarios where cell A1 has data, is not completely
displayed,
and cell B1 also has data - In that scenario, A1 needs to be autofitted,
since B1 covers it- (example works with any adjoining cells). Is the only way
to calculate
the column width and length of text in A1? - is there a way to do that
calculation accurately (since column text can vary based on characters)?

tia,
dk

 

[NickHK]

The only (practical) way I know is to copy the text to a cell out of the
way. Autofit. Compare the widths of the columns.

NickHK