Welcome to the Forum LewWalker,
You can use the On Change Event behind the worksheet. Select the worksheet tab and then use right mouse button, then at the top the left drop down change to Worksheet then the right drop down change to On Change
In the space between the on change event and End Sub you would add in something like this..
Code:If Range("F6")="What ever the contents needs to be Then" Rows("20:35").EntireRow.Hidden = False Call SearchMacroName End IF