Link to home
Start Free TrialLog in
Avatar of Frank Freese
Frank FreeseFlag for United States of America

asked on

Hide a row based upon a cell value using VBA

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.
ASKER CERTIFIED SOLUTION
Avatar of Martin Liss
Martin Liss
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Frank Freese

ASKER

Glad to hear from you. Hopefully you and the family enjoy good health away from those fires this past fall.
You code worked GREAT
As always, thank you for your help
You're welcome, and while we had unsafe air for a few days, we weren't near the fires.