We help IT Professionals succeed at work.

Hide a row based upon a cell value using VBA

53 Views
Last Modified: 2019-02-08
Folks,
In my spreadsheet I have cells in a column where the data depends upon a list data validation. Let's say my cells are located in column E. If any cell in that column ="Completed" I would like a command button, that when clicked, will hide any rows not already hidden where the cell value = "Completed". I need VBA help here for my command button, please.
Comment
Watch Question

Protect yourself and your loved ones. Stay home for the holidays.
CERTIFIED EXPERT
Most Valuable Expert 2017
Distinguished Expert 2018
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION

Author

Commented:
Glad to hear from you. Hopefully you and the family enjoy good health away from those fires this past fall.
You code worked GREAT

Author

Commented:
As always, thank you for your help
Martin LissProtect yourself and your loved ones. Stay home for the holidays.
CERTIFIED EXPERT
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
You're welcome, and while we had unsafe air for a few days, we weren't near the fires.