hide rows and columns

  1. L

    Hide Rows and Column in multiple sheet based on a cell value of another sheet

    Hi All... I am new to vba and still wanted to learn. I need your help to solve my problem. I would like to know how I am able to add more task on below vba to hide rows and columns of multiple sheet based on a cell value of another sheet. Let say: On Sheet1, If I enter a value of 7 (this is...
  2. F_Rowan

    Macro to hide hide rows/cols below/right of current selected cell

    Hi Experts - I am seeking VBA code that will hide all rows below and all columns right of the currently selected cell of the current active sheet. i.e.; If the current selected cell is F23, the macro should hide all rows below row 23 and all columns to the right of column F.
  3. D

    Hide/Unhide Rows when Hyperlink is clicked

    So I have 4 sheets, an Index and 3 error sheets. The index has each error type in row 1 Row 2 has Sheet 1 errors Row 3 has Sheet 2 errors Row 4 has Sheet 3 errors I need a code to look at the error type in row 1, column B, C, or D, and hide certain rows on the relevant sheet when the...
  4. E

    Hiding rows and/or colums by using drop-down-lists (multiple selections)

    Dear all, For my job I've to create a new user-friendly template for a lot people who no only the basic of Excel. How is it possible to hide columns or rows with a drop down list? I've a drop down list linked to cell A3. So select the first option in the list, then A3 will be 1, select the...
  5. F

    Code to Hide Rows based on criteria in linked cell

    I have read about 50 threads and cannot seem to get a macro code to work and I am not well versed in VBA so I have been trying to cut and paste certain codes to get to one that works without success. My workbook contains an "Expense" tab and a "RPT" tab. The RPT! tab pulls data from a separate...
    • fin_analyst
    • Thread
    • calculate() external datasource hide rows and columns multiple criteria
    • Replies: 0
    • Forum: Excel Questions
  6. S

    Worksheet Macro to Hide Rows and Columns based on multiple cell values

    Hi, I have two different data validations with dropdown lists on a worksheet. The first list in cell B20 is for a type of chair. The second list in cell H20 is for the backrest type of chair. If I select "Task" in cell B20 and I select "Mesh" in cell "H20" then I want rows 31:32 to be not be...

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