Hello!
Im using this code to hide empty rows. It works fine but the problem is that I have a few graphs in this sheet and it takes really a lot of time to execute the macro.
I was wondering if there is maybe a quicker way of running this macro like selecting the whole rows which are empty and hide them all at once instead of going one by one...
Please Login or Register to view this content.
Thanks for the help!!
Regards,
If there is no data above row 45, try turning on your macro recorder and filtering blanks from the B column. Make sure afterwards that you add the lines to set calc to manual and turn off screen updating. As a general rule, selecting cells, then executing commands on them is not nearly as fast as iterating through a collection such as the cells, rows or columns collection, or just using a built in Excel feature such as filtering.
If your question has been satisfactorily addressed, please consider marking it solved. Click the Thread Tools dropdown and select Mark thread as solved.
Also, you might want to add to the user's reputation by clicking the star icon in the lower left corner of the post with the answer- it's why we do what we do...
Thomas Lafferty
Analyst/Programmer
Hi,
Well there is actually data in those rows. It goes changing depending the input.
Its a good way and very quick actually doing it with autofilters. The only thing is that I would not like to have the filter tab on the row...
Regards,
Maybe this would work for you
Please Login or Register to view this content.
Thanks,
Mike
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
Try this...Please Login or Register to view this content.
And it works!!! Goes perfect gents!!!
Thanks for all!! Good solution!
Regardsss
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks