Need VBA to hide rows beased on text and blank together

[g1terra]

i need a VBA code to hide rows based on text in a column. And also if the text is blank to hide as well.

This is what i have so far I am missing the OR part of this formula to make it work to hide the blank text rows as well.

Any help is greatly appreciated!

Please Login or Register  to view this content.

[jindon]

change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

[g1terra]

Thank you!!

[jdp949]

I am completely new to VBA and forums, with that said here is my question.
I want to accomplish something very similar to the original questions but with columns. I want to have a button on worksheet "Selections" that when unchecked it hides a column on worksheet "Data Table".
I accomplished this with the simple code of:

Private Sub CheckBox12_Click()
['Data Table'!N:N].EntireColumn.Hidden = Not CheckBox12
End Sub

I attached this code to all 50 or so selection buttons that correspond to different columns in worksheet "Data Table".
I also added a Select All button and Clear All button that work well.
My problem is that if I add a column (new data series) to worksheet "Data Table" all of my checkboxes now point to the wrong column.
So I was trying to figure out what VBA I should use so that it looks in worksheet "Data Table" in row 2 for specific text and then hides the column or columns that match that text.

Any thoughts?

[jolivanes]

@jdp949
At the top there is a "Forum Rules". Click on it and read #2 and 3 before commencing please.