Excel VBA to hide rows based on cell value

[Stuepef]

I am looking to write VBA to hide 2 rows on Sheet10 (code name) based on cell value on Sheet1 (code name). The logic I am looking for assistance on is the following:

If Sheet1 cell C33 does NOT = "Apple" then hide Sheet10 rows 108 & 109, but if cell C33 is blank, then do nothing.

Thank you!

 

[Fluff]

Something like

   If Sheet1.Range("C33") <> "Apple" And Sheet1.Range("C33") <> "" Then
      Sheet10.Rows("108:109").Hidden = True
   End If

 

[Stuepef]

@Fluff - works like I want, thank you as always!

 

[Fluff]

You're welcome

 

[Stuepef]

@Fluff - How would I update the code you provided if I wanted rows 108 & 109 to be hidden across Sheets 10, 11 and 12?

 

[Fluff]

Just copy the line that hides the rows & change the sheet name

 

[Stuepef]

Always helpful, thank you!

 

[Fluff]

You're welcome