Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
2007 AutoFit, WrapText, fails
I use VBA macros to custom sort a range of columns and rows. All the cells
are set to WrapText. In one of the columns, each cell has data that makes the cell height variable depending on what data resides in that cell (hence Wraptext), thus row height variable. After sorting using the VBA macro, The pre-existing cell heights don't change to match the wrapped text. I have tried manually AutoFit and also AutoFit the range rows in the code without success. Here is the weird part. If I add a manual line feed to the data just as a test, AutoFit will resize properly on sorting. Any ideas? Thanks, facmanboss |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
2007 AutoFit, WrapText, fails
Hi,
Try this, With you column , remove the wraptext property sort your data and apply the wraptext property to your column. It should worked fine ! "facmanboss" a écrit dans le message de groupe de discussion : ... I use VBA macros to custom sort a range of columns and rows. All the cells are set to WrapText. In one of the columns, each cell has data that makes the cell height variable depending on what data resides in that cell (hence Wraptext), thus row height variable. After sorting using the VBA macro, The pre-existing cell heights don't change to match the wrapped text. I have tried manually AutoFit and also AutoFit the range rows in the code without success. Here is the weird part. If I add a manual line feed to the data just as a test, AutoFit will resize properly on sorting. Any ideas? Thanks, facmanboss |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Autofit/wraptext on vbLf problem | Excel Programming | |||
Excel 2007 autofit row height | Excel Discussion (Misc queries) | |||
Excel 2007 Autofit | Excel Discussion (Misc queries) | |||
Excel 2007 Autofit row/column height | Excel Discussion (Misc queries) | |||
Range WrapText and AutoFit with Bold | Excel Programming |