hide row cell value

  1. S

    hide button for rows based on cell value

    hello everyone, i need a button that hides and unhides rows based on cell value of the column (No. Date) if the date is more than 6 days ago it becomes hidden, and whats left is the recent ones which are this week. but i can hide and unhide it whenever i want that’s important it’s important...
  2. J

    VBA Code for hiding rows with zero value then hiding when value changes

    Hello, Would anyone be able to give me a code for hiding rows 17:39 if the value in column D is zero, then unhide if the value changes to greater than zero? Thank you
  3. D

    Excel VBA hide rows from range with value at multiple protected sheets

    I have tried finding code for hiding rows from range with value criteria, with applying it to multiple protected sheets. Could someone help build the right code.Original code as following (i'll explain what i would need after the code): Sub CreatePDF_ERIKHONOKRISSEPETE() sheetname =...
  4. D

    Hide / unhide rows based on value

    Hi guys, This is my first time actually posting here so here goes: The question is simple enough (I hope); I have a master spreadsheet that controls two slave spreadsheets. Layout-wise they are more or less identical, the columns are slightly different but the rows are exactly the same. The...
  5. L

    Hide Rows Depending on Cell Value (Text)

    I am writing up a Macro to be used in my worksheet and I was hoping that you could please help me figure out why it’s not working exactly how I intended. I have a worksheet that pulls information from several other worksheets to provide a score and any discrepancies observed. I am trying to...
  6. S

    VBA Assistance to Hide Rows based on values

    I am new to posting here, so please pardon any newbie statements or questions! So, I have seen several recommendations for VBA code to Hide Rows with VB based on a cell value, but it seems that none are exactly what I am looking for, any help would be greatly appreciated. On our spreadsheet...
  7. P

    hide a row when a cel is no

    hello, I'm new here . I've searched this forum for a vba code to hide a row (or even more rows) when a cell value is no and unhide when the cell value is yes. i found different vba codes to use a button but i want to use no buttons, it must be automated. please could anyone help me with this??

Some videos you may like

This Week's Hot Topics

  • Problem in vba vlookup
    Dear All Master, The problem I mean is as follows : 1. I want to modify the vba code because it takes too long/very slow to vlookup in VBA code...
  • VBA Vlookup
    Please for help. Why it`s not works? [CODE=vba]Sub Check_equpment1_click() Worksheets("Production_program").Activate Dim ans1 As Integer ans1 =...
  • Nesting INDEX MATCH into SUMIFS
    I currently have several formulas pulling in a SUMIFS from a data sheet, beginning with =SUMIFS('datasheet'!$N:$N, 'datasheet..... but as I am...
  • Extracting number from a range randomly
    Hello Expert, please kindly advise what is the best method to extract numbers from a range randomly I have a series of numbers in the range of A1...
  • Problem with If Formula
    I am using the following formula in cell A5. I would like if N5 is blank then A5 also return blank. If N5 is 0 or is greater than zero then equals...
  • Is there a way to make the day's name show up automatically in a header?
    I have a form I print out every day..and in the top right custom header I have the &[DATE], which automatically gives the current date in top...