Hide rows based on criteria over multiple columns

[fg-rod]

Hello,

I need help with a code that will search each cell across 4 columns and hide the row only if all cells are blank. The macro should search columns "b", "c", "e", and "f" to display all rows where at least one of the cells has a value.

Ex.

Col.B Col.C Col.D Col.E Col.F
1. 123 xxxxx 150
2. 56 xxxxx 50
3. (blank) (blank) xxxxx (blank) (blank)

In this ex. row 3 would be hidden.

Any help will be greatly appreciated.

 

[fg-rod]

So sorry for the format of my thread. This is my 1st time using this forum. Here is goes again.
Hello,

I need help with a code that will search each cell across 4 columns and hide the row only if all cells are blank. The macro should search columns "b", "c", "e", and "f" to display all rows where at least one of the cells has a value, and my data begins on row 7.


Any help will be greatly appreciated.
Thank you