2007 AutoFit, WrapText, fails

[facmanboss]

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

 

[michdenis]

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" <[email protected]> a écrit dans le message de groupe de
discussion : (e-mail address removed)...
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