Resize Visible Rows based only on Visible Columns text
Hi All,
If possible, could someone help with the correct code to resize all visible rows on a sheet based only on the text in the visible columns.
I have tried the below code but when it resizes it is using the largest amount of text in the rows including that in the hidden columns.
Cheers
Please Login or Register to view this content.
Last edited by Zimbo; 04-22-2009 at 09:22 PM. Reason: No help available
I don't think you're going to charm Excel into doing that. Excel is pretty column-centric.
Entia non sunt multiplicanda sine necessitate
Re: Resize Visible Rows based only on Visible Columns text
Hi shg,
Thanks for your reply.
Is there no way to find the cell(visible) in a row with the most text and resize the row accordingly then go to next row?
Cheers
Maybe, if you deleted the data in the hidden columns in the row, autofitted the row, and then put the data back.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks