Auto Hide Rows Based On Vlookup Outcome

[VBNewbiwe83]

Hi.

I have a spreadsheet where cell D26 is populated with 2 outcomes “workable” and “non-workable” as the result of a vlookup against 2 other cells.

I want to hide rows 27, 29, 35, 37, 38, 39, 56, 57, 59, 60, 61, 63, 65, 71, 78, 79, 80, 81, 82, 83, 84 and 86 If workable is populated, and leave as is if blank or “non-workable” populated.

Can you help please?

Thanks

 

[rpaulson]

try this, ad inn your rows numbers as needed.

  If [D26].Value = "workable" Then Range("27:27,29:29,35:35,37:39").EntireRow.Hidden = True

hth,

Ross