This version of the macro actually checks three conditions: that B4 is not empty, that it contains a numeric value, and that the value is 0. In that case, you can modify the macro just a bit so that it checks for an empty cell. If it is possible that the contents of cell B4 could be empty, then it is possible that Excel will interpret that emptiness as a zero value. This means that every time you move from one cell to another, the value in B4 is checked and column H is either hidden or unhidden. The only difference is that the second version is triggered by an event within Excel-the changing of which cell is currently selected. Notice that the guts of the two macros are the same.

Private Sub Worksheet_SelectionChange(ByVal Target As Range) Just make sure that you put this version in the code window for the worksheet on which you want it to work. If you want the hiding and unhiding of the column to be done in real time, you can use the following version of the macro.

If cell B4 does not contain 0, then column H is displayed. The following simple macro, for instance, examines the contents of cell B4 and, if the cell contains 0, hides column H. You can, however, achieve the desired effect by using a macro to analyze the cell and adjust the Hidden attribute of the row you want to conditionally hide. There is no way, unfortunately, to easily hide entire columns of data based on the value of a particular cell. Excel's great conditional formatting capabilities allow you to change the formatting of cells based on the content of a cell.

Excel vba on change column