First of all I am a complete novice at VBA Macros.
So I have 2 buttons at the top of my sheet. One says "Hide" and the other says "Unhide" If any cells in the same row of columns B AND C equal 0 then I want the button to Hide those entire rows. If a cell in B4 has a value of 0 but C4 has a value of 1 then it should not hide. Only if cells in the same row of columns B & C = 0 should the macro hide that row. Obviously the other button would unhide them. Here is what I have so far, My problem seems to be that I don't know how to code the macro to read the entire columns of B & C. Any help is greatly appreciated!
Bookmarks