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.
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.
Glad to hear from you. Hopefully you and the family enjoy good health away from those fires this past fall.
You code worked GREAT
You code worked GREAT