Hide Blank Rows & Those With "" Empty Text

  • Hi All

    I have a macro that hides a row if a cell in that row is blank. The VBA code is shown below.

    With Edin_Cap
            .Range("B26:B36").SpecialCells(xlCellTypeBlanks).EntireRow.Hidden = True
            .Range("B44:B86").SpecialCells(xlCellTypeBlanks).EntireRow.Hidden = True
            .Range("B93:B124").SpecialCells(xlCellTypeBlanks).EntireRow.Hidden = True
        End With

    I have discovered that this formula becomes a problem where a cell might contain a formula but no value. For example, if the cell contains the formula:


    if the above value is "" then the 'hide entire row' macro doesnt work. How can I hide a row if the cell VALUE is blank?



Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!