ListObjects

[costadina]

I wrote some code that with the click of a button called "FILTER" it converts several ranges into independent ListObjects with this code:

Please Login or Register  to view this content.

and then automatically filters out zeros and blanks based on data from one column called "Qty" using this code:

Please Login or Register  to view this content.

Then with the click of another button, I reset the ListObject back to a range with this code:

Please Login or Register  to view this content.

The above works fabulously. Here's the problem.

I have quite a few columns in the table and I wish to print everything out on one sheet. That's easy enough. I just format several column widths to equal 8. The problem comes in, when the range turns into a ListObject, these columns widen to fit the text in the column headers. I set the cell format for "wrap text", but that doesn't cure it. How do I keep the column width from widening after converting a range into a ListObject?

[Leith Ross]

Hello costadina,

This code will make all the text in the cells of the ListObjects wrap around.

Please Login or Register  to view this content.

[costadina]

Hi Leith

Good idea.
You would think that would work but it doesn't. It failed to wrap the text.

I even tried

Please Login or Register  to view this content.

It narrowed some columns, but the columns with the long text string in the header row did not wrap. I love Excel