I need help w Excel VBA. Code shown is my attempt, ITS DOES NOT WORK, IT DOES NOT UNHIDE ANY ROWS. PLSSS HELP its my seventh time asking for help on chegg :$(.$ 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 seventh time asking chegg because it doesnt work. Thanks! will upvote if correct