I want to create a piece of VBA code.
If a cell in row 5 - column b to columnaz includes the text EntityA or EntityQ then:
The column should not be hidden. The remaing columns in column b to columnaz should be unhidden.
Then I want to create another macro to unhide all unhidden columns.
If a cell in row 5 - column b to columnaz includes the text EntityA or EntityQ then:
The column should not be hidden. The remaing columns in column b to columnaz should be unhidden.
Then I want to create another macro to unhide all unhidden columns.