I have an Excel range that is hidden. I want to unhide only rows in that range C2:F21 that contain a specific value. The value comes from a userform in TextBox3.

Since find does NOT work on hidden ranges, as far as I can tell, how can I use the Match function to look into the range to do this, OR is there some other useable approach using VBA
( Preferred Solution )

Thanks