Hide Column If Cell Value is empty from Checkbox

Hi,

I´m looking for a macro were i could filter columns based on its cell value in a specific row (5) with a checkbox placed in row 5. So for example if a column in this specific row 5 is empty then it should be hidden when the checkbox is ticked. The sheet containt multiple rows with the same function, which makes it a little complex. If the same column, in row 6 contains a value, then the coloumn should not be hidden even though checkboxes from row 5 and row 6 is ticked.

There is also 2 specific columns that should be independent and should not be hidden in any case.

I have tried many codes with the best i could was to hide all columns even though they contained a value....


Pleases se attachment.

Best regards, Guple

Thanks, this worked like a charm!! :D

Though i still wont get to work as good as it need... I need the macro to prioritize the rows with the checkboxes så they never hide a cell that contain X.

The concept is to choose wish rows i want to focus on with the checkboxes, and then let the macro hide the choosen rows columns that is is empty and only show the columns with X. But if i choose 2 rows etc. and one of the rows contains more x and then the other, no columns that contain x should be hidden.

I explained in the excel file with color! Should be easy to understand.


Book4.xlsx

What does this mean?

Thank you!!

" For c = 5 To 13
If Cells(5, c) = "" And c <> 7 And c <> 10 Then Columns(c).Hidden = True "

¨BUMP! Would really appreciate some help here...

Best regrads, Guple

BUMP! Would really appreciate some help here...

Best regrads, Guple