-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
hide rows based on a columns value
alansidman
Well-known Member
- Joined
- Feb 26, 2007
- Messages
- 8,342
- Office Version
- 365
- Platform
- Windows
A VBA solution is available but only if you provide the details/criteria for hiding the column.
Upvote
0
My Aswer Is This
Well-known Member
- Joined
- Jul 5, 2014
- Messages
- 19,621
- Office Version
- 2021
- Platform
- Windows
We always need specific details.
Like in your case we need to know
1. How do you want the vba script activated ?
2. What column will this value be entered into?
3. What value will this be?
For example you need to say something like this:
When I enter "Alpha" into any cell in column A I want that row hidden
Or when I click on a button hide all rows with Alpha in Column A
And how do you plan to unhide the row?
Like in your case we need to know
1. How do you want the vba script activated ?
2. What column will this value be entered into?
3. What value will this be?
For example you need to say something like this:
When I enter "Alpha" into any cell in column A I want that row hidden
Or when I click on a button hide all rows with Alpha in Column A
And how do you plan to unhide the row?
Upvote
0
