I need help w Excel VBA. Im trying to write a code that hides rows based on a dropdown selection. For example as shown in the picture, Chemical name B is selected from a dropdown on C$3.$ What i want the code to do is unhide everything as a reset, then hide rows below $8$ then loop through each row looking for the chemical name $($in this case B$).$ Then unhide the row where the selected chemical is at and ALSO unhide the $2$ consecutive rows below it$.$ Pleaseeee plssss check that it works and it does what im saying i need $3$ rows to be unhidden. This is my fifth time asking chegg because it doesnt work. Thanks! will upvote if correct