Excel VBA to Unhide rows with a specific value in a Range

[simora]

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

[p45cal]

You want to find the value that's in TextBox three among ALL the cells in C2:F21 (ie. all columns and all rows of that range)?

ps.
.Find will search hidden cells if you use LookIn:=xlFormulas, assuming there are no formulas, that is.

[simora]

You want to find the value that's in TextBox three among ALL the cells in C2:F21 (ie. all columns and all rows of that range)?

ps.
.Find will search hidden cells if you use LookIn:=xlFormulas, assuming there are no formulas, that is.

[simora]

p45cal (http://www.vbaexpress.com/forum/member.php?3494-p45cal):

RE: You want to find the value that's in TextBox three among ALL the cells in C2:F21 (ie. all columns and all rows of that range)?

To answer your question: Yes!

[p45cal]

Something along these lines
Private Sub CommandButton1_Click()
For Each rw In Range("C2:F21").Rows
For Each cll In rw.Cells
If cll.Text = TextBox3.Value Then
cll.EntireRow.Hidden = False
Exit For
End If
Next cll
Next rw
End Sub

[simora]

p45cal:

Thanks.

The code worked as expected without any errors.