Hiding Rows based on a cell Value that is a result of a formula

Hey Guys i have a sheet where im trying to have rows Hide or Un-hide off of a Yes/No.

Initially i had the value be a manual input from a validation list (Yes/No) and the script worked fine:

If Range("D10").Value = "Yes" Then
Rows("153:191").EntireRow.Hidden = False
ElseIf Range("D10").Value = "No " Then
Rows("153:191").EntireRow.Hidden = True
End If

I had to split the table onto two separate worksheets so i could lock one through scripting. Now the value is being placed by a formula:

=IF('HRC Inputs'!D10:E10="","",IF('HRC Inputs'!D10:E10="Yes","Yes","No"))

How can i make the scripting still trigger off of the value in the cell if it is placed there by a formula and not manually inputted?

Thank you!

try manipulating:

Please Login or Register  to view this content.

Originally Posted by jewelsharma

try manipulating:

Please Login or Register  to view this content.

i tried:

Please Login or Register  to view this content.

It still will not hide the rows unless i manually input the Yes or No.

I think Range.HasFormula can only return True or False. It cannot be "Yes" or "No". So please try the following again:

Please Login or Register  to view this content.

Let us know if anything.