Hi can anyone help me with some code for hiding rows.
I have one cell (B2) where you can select different options (in my example, numbers 1 to 4).
If I select "1" in this cell (B2), I would like to only show the rows that have "1" in column A. So hiding rows 6, 8 and 9 in the table.
If I select "2" in cell B2, I would like to only show the rows that have "2" in column A.
Etc.
Untitled.jpg
Help would be much appreciated!!
For starters, in SheetModule.
Please Login or Register to view this content.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
Please Login or Register to view this content.
"ThankyouFor Attention * And Your Help!!"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks