hide rows automatically

  1. R

    Help with auto Hide/Unhide rows without rerunning VBA

    Hello, my name is Ryan, I've been using different codes to accomplish hiding rows on my sheet, which work but as I go along, and the cell changes it does not unhide rows like I thought it would. I have a safety meeting data on a spreadsheet, one sheet (Safety Meeting 101) is an interactive...
  2. C

    Automatically Hide Rows Based On Cell Ref

    Hi, I would like a page within my macro enabled workbook to automatically hide and unhide rows based on the cell reference within column C of each row. Page Name "Pilot Log" Possible text references within column C would be "MA" "SA" "P3" "P4" "P5" The rows I would like to hide / unhide...
  3. A

    VBA - Hide Rows based on two Cell Values

    Hello, I have a table with two columns (min value and max value) and I want to filter the rows typing in the desired range in two separate cells. I have achieved to make it for the first column. It is as follows: Sub SearcRange() 'Hide Dim Cell As Range Var = Range("C1").Value...
  4. A

    Use VBA to hide non sequential range of rows based on the cell value

    Hi I am trying to create a form where there is a drop down boxes for selection of 4 options (cell G12). This is what I would like the programming to do: Cell G12 – there are 4 selections now If blank Rows 36:66 hidden True Rows 80:88 hidden True If DVA Initial Rows 36:50 visible True...
  5. B

    Hide rows based on a cell refrence

    Hi all Here is what I am looking to do: when a store places an an order they place it for X amount of product, sometimes the store will place the order for 9 items or up to 16 items. i have created a sheet that displays all 16 of those items on individual rows, but I don’t want a lot of dead...

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