Hi all, been struggling to find/write a macro that will hide all rows (there are 1184 of them) that do not contain any cells with a -9 value somewhere in it. The column range is A through IE. Does anyone have any insight on how to accomplish this?
See attached example, I would only want to keep rows 4, 6, and 8 as they are the only rows containing a -9 value.
Last edited by jgc123; 12-12-2019 at 11:51 AM.
To attach a file, click the "Go Advanced" button. Then scroll down a bit and click "Manage Attachments".
You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
Practice makes perfect. I'm very far from perfect so I'm still practising.
attached, thanks
Try:
Please Login or Register to view this content.
Thank you so much!
You are very welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks