I'm not sure if this is possible, but I need to write code to hide an entire row if the cells in columns B-F ALL equal either N/A, TBD, or Unknown. Or, to put it another way, if any cell in column B-F has a date, I do NOT want it to be hidden.
For example: I would want rows 1 and 4 below to be hidden automatically (but this is just an example from a much larger worksheet).
A B C D E F
11003 N/A N/A TBD TBD TBD
11006 N/A N/A 28-Oct-11 N/A 28-Oct-11
11007 N/A N/A N/A N/A 20-Feb-12
11009 N/A N/A TBD TBD Unknown
Is there a code that can do this?