hide multiple rows

  1. D

    Hide Multiple number of rows based on a value

    Hey There - New to VBA & I need to workout how to hide a certain number of rows from a different worksheet based on the value inserted on another worksheet. Details are: * 'Summary' worksheet cell 'H10' the user inserts a value (e.g. 350), which is the # of records which will need to be...
    • Donna216
    • Thread
    • hide multiple rows records vba vba & excel worksheet
    • Replies: 5
    • Forum: Excel Questions
  2. I

    VBA Script to hide rows

    Hi there I'm trying to build a code that will look down column A, containing case references, and hide the row if part of the case has been rejected, col c. Now this is simple enough but the problem is that there can be any number of parts to a case and each part is recorded on a new row, so a...
  3. A

    VBA: Hide/Unhide Multiple Rows

    I have searched through this forum and Googled too, but couldn't find an efficient solution to my task. I have a workbook with multiple tabs. Each tab has about 600 rows. In each tab, I need to hide/unhide rows based on the value of a particular column in that row. For example, Row1...
  4. V

    Any Better Ideas for Hiding Rows

    Hi I've used the forum to create some code that hides particular rows based on a validation list in cell C6 here is the code: Private Sub Worksheet_Calculate() Dim MyResult As String Application.EnableEvents = False Rows("1:" & Worksheets("Cutting Sheet for Std...
  5. R

    How to hide/unhide multiple rows where the result is 0 in column A

    Hi there, I have this code but it only hides rows based on a single cell result. I really need to hide multiple rows based on result in column A (so this changes) I have honestly spent the whole morning looking for and trying different options from different forums but keep getting erros. As...

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