hide row cell value

  1. 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
  2. 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 =...
  3. 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...
  4. 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...
  5. 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...
  6. 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

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...