Hi ,
I need some code to hide a column if all the cells have been reported as n/a
My data always starts on row 3 , the first two rows are headers and the number of rows would need to be dynamic as it could change.,
Example , from the below table the macro would hide column C
I have been looking online and there are a lot of examples of hiding rows based on cell value but I cant find anything to hide columns based on the cell value of all the cells in that column.
Any help is greatly appreciated
Thanks.
I need some code to hide a column if all the cells have been reported as n/a
My data always starts on row 3 , the first two rows are headers and the number of rows would need to be dynamic as it could change.,
Example , from the below table the macro would hide column C
A | B | C |
Test 1 | Test 2 | Test 3 |
Test | Test | n/a |
Test | Test | n/a |
Test | n/a | n/a |
Test | n/a | n/a |
Test | n/a | n/a |
I have been looking online and there are a lot of examples of hiding rows based on cell value but I cant find anything to hide columns based on the cell value of all the cells in that column.
Any help is greatly appreciated
Thanks.