row hide

Good Morning All, I'm wondering if someone can help me with the attached sheet i have created. I am looking to hide rows on the "Specification" Sheet when column 'E' shows "N". By doing this i also need Excel to hide the linked Word Document Object in each row. To have column "E" change to...

Good Afternoon, I am new on the forum and I didn't find the answer to my problem within the existing posts so I hope you will be able to help me. I created an excel document that includes over 200 sheets. The purpose is to have inputs from the production team on each sheet. The document is...

The general format I use for hiding rows is If Range("G17") = 1 Then Range("G22:G26").EntireRow.Hidden = True Else Range("G22:G26").EntireRow.Hidden = False End If In one particular case I want the rows to hide based on an embedded value (that is calculated rather than being entered or...

Hi All, Im writing a micro to do a search for me. I have an arrary of values on sheet1 (A9 to DB324) and a second array of values on sheet2 (A3 to A19). Im looking for a way search the arrary on sheet1 (the values will be in column E) for the values on Sheet2 and hides any row that does not...

I have a spreadsheet with a number of characteristics listed (column E), each with a set level at which they become available (with the level shown in column B) and a points cost (column G). Some require other characteristics as prerequisites (column I), others are duplicated elsewhere on the...