Unhide/Hide rows in range based on value (improve code)
Hi,
I have implemented a macro button which hides/unhides cells within a range based on their value. It works correctly but the only way I could figure out to do it was via an autofilter and it seems a bit slow.
I used "<>" because I can alternate between hiding blank cells and hiding cells equal to 0.
Any help to create a quicker solution would be much appreciated.
Please Login or Register to view this content.
Thanks,
M
Try this code
Please Login or Register to view this content.
< ----- Please click the little star * next to add reputation if my post helps you
Visit Forum : From Here
Thanks for your response YasserKhalil.
This didn't seem to solve my problem. I'm looking to move away from using AutoFilter and just hide the relevant rows if that would speed it up.
Additionally, I've realised that I have two sections attempting to AutoFilter on the same page so my formula won't work.
Last edited by MP1286; 02-03-2017 at 10:33 AM.
Managed to solve this one via the following:
Please Login or Register to view this content.
Double post.
Last edited by MP1286; 02-03-2017 at 11:06 AM.
Glad you can figure it out yourself
But using loops is slower than filter method I wonder ..
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks