| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 Can't scroll to top row which is partially hidden | Excel Discussion (Misc queries) | |||
| Horizontal Scrollbar partially Hidden by Taskbar | Excel Programming | |||
| How do I detect hidden worksheets or hidden data on a worksheet? | Excel Discussion (Misc queries) | |||
| How to detect if cells text go on other column ? | Excel Programming | |||
| Cells partially hidden in print preview | Excel Discussion (Misc queries) | |||
Linear Mode
