Hide Rows using VBA

[Tallulah2714]

How do I write VBA code in Excel 2016 in order to have a particular set of rows within in a workbook hide if they do not contain any numerical or text information? The rows I am referring to have an "if" function in their cells that will pull data from a separate area of my workbook if certain information is pertinent to that formula. If those cells are empty, I want them to hide. If the cells then contain data, they should remain present.

Thank you!

 

[mrmmickle1]

To hide rows use code like this:

  Rows("8:11").EntireRow.Hidden = [COLOR=#0000ff]True[/COLOR]

If you want to go through a specific set of cells to identify if the rows need to be hidden you could do it with a loop... i.e.\

[COLOR=#0000ff]Sub[/COLOR] Test()
   [COLOR=#0000ff] Dim[/COLOR] intLp [COLOR=#0000ff]As Integer
[/COLOR]
  [COLOR=#0000ff]  For[/COLOR] intLp = 2 [COLOR=#0000ff]To[/COLOR] 10
       [COLOR=#0000ff] If [/COLOR]Sheets("Sheet1").Cells(intLp, "A") = "x" [COLOR=#0000ff]Then[/COLOR]
            Rows(intLp).EntireRow.Hidden =[COLOR=#0000ff] True[/COLOR]
[COLOR=#0000ff]        End If[/COLOR]
[COLOR=#0000ff]    Next[/COLOR] intLp
[COLOR=#0000ff]End Sub[/COLOR]

 

[Tallulah2714]

Thank you. So the specific rows would be the 2 to 10?