ListObject

I wrote code that on the click of a button "FILTER", the code will automatically convert several ranges into individual ListObjects and then filter out blanks and zeros from one of the columns.

Then on the click of another button "UNFILTER", it will automatacally unfliter the table and convert the ListObject back into a range.

Here's the code:

To Filter:

Please Login or Register  to view this content.

To Unfilter:

Please Login or Register  to view this content.

where Ows is an ActiveSheet variable

The code works just fine. Here is the problem.

When I click FILTER and the range converts to a ListObject, several of the narrow columns automatically widen to fit the the width of the header text. I had set the column width to 8, and set the cell format for "wrap text", but upon conversion from range to ListObject, the text does not "wrap" and the row does not widen to accomodate wrapped text. Instead the column widens, which is what I don't want since it becomes too wide to print.

Anyone have any suggestions on how to fix this?

Hello costadina,

Please change the title of this thread. You have already used this title in another post http://www.excelforum.com/excel-prog...stobjects.html.

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.