vba to detect if column contains partially hidden text
 

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

vba to detect if column contains partially hidden text
 

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
"dk" wrote in message
...
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

vba to detect if column contains partially hidden text
 

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

"Otto Moehrbach" wrote:

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
"dk" wrote in message
...
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

vba to detect if column contains partially hidden text
 

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

"dk" wrote in message
...
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

"Otto Moehrbach" wrote:

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
"dk" wrote in message
...
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