hide by value

  1. S

    VBA code to automatically hide rows

    I want to find a way to automatically hide rows in Excel when any particular cell is 0 within a specified column. In the example below, after running the macro, the column on top would collapse and then it would look like the column on the bottom (since the cells with 0 would have their rows be...
  2. J

    If true, hide Range("P:U") & Range ("V:AA")

    Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Range("H2"), Target) Is Nothing Then If Worksheets("2016!").Range("h2") = "SIS" Then Range("P:U").EntireColumn.Hidden = True Range("V:AA").EntireColomn.Hidden = False 'this line gives a...
  3. S

    Hiding rows based on a cells value (Macro)

    Hi, I am a VBA beginner, trying to figure out how to hide rows based on the value of a cell. I have seen similar posts that did not quite answer what I am trying to do. If cell A3 = "Brand", I want to hide all rows where C9:C2000 NOT= "Brand" Else if cell A3 = "Other", I want to hide all rows...
  4. A

    Macro for Hiding Large Amount of Rows (2000+) based on cell value

    Hello All, I’ve tried numerous approaches to this problem and the macro still works far too slowly. I am trying to develop a macro that takes the range A16:A2015 and hides the row if the cell value=1 and leaves it if the cell value=0. Ive tried the following: Sub test() Dim Last_Row As Long...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top