For the record, I did complete a search on the forums for this issue, but was unable to find a good match for the solution I need.

Following some great programming skills and advice from VBA Noob, I now have a summary page that provides a listing of data based on array formulas (a cool rather long array formula in which each cell contains the following functions: IF, SMALL, ISERROR, INDEX, ROW and COLUMNS!).

I would now like to take the results on this summary page (which are generated from the array formula) and hide any row within a select range (e.g., C10:F:50) where the value in each of those four columns for a single row all equal "" (no result). In other words, if C14, D14, E14 and F14 all equaled "", then the row would be hidden.

I would like this to work automatically and also want it to unhide the rows automatically. For example, if I changed the criteria such that now D14 displayed the value, the row would unhide and show the result. If not possible, then I'd defer to setting up macro button(s) for the same push (manual) result.

Looking forward to any response! Let me know if you need more details.

Thanks!