Hide a row based upon a cell value using VBA

Frank Freese
Frank Freese used Ask the Experts™
on
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

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Older than dirt
Most Valuable Expert 2017
Distinguished Expert 2018
Commented:
Try this.
29135287.xlsm

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 LissOlder than dirt
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.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial