I use the following code to count filtered rows:
And I would like to hide all filtered rows which are greater than the above count in the range of the filtered rows.
Please Login or Register to view this content.
For example if I have 25 filtered rows (25 visible), I would like to show only 20 of them and hide the rest of the filtered rows.
Last edited by neobux; 03-25-2016 at 02:55 PM.
Please Login or Register to view this content.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Please Login or Register to view this content.
Last edited by graym463; 03-25-2016 at 12:54 PM. Reason: error in hiding
While the above were working fine, they were a bit slow for my needs, so I ended up using the following function:
And adapted it to the following code:Please Login or Register to view this content.
Thank you guys for pointing me in the right direction, much appreciate it.Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks