ok i need help...i somewhat knowwhat i need but need help doing it...if anyone can help it would be much appreciated. i have a sheets with about 1420 rows and 3 columns. i have a text box and a button. i need to have the user input there search in to the textbox and press the search button and only rows meeting the search cracteria will show and the rest will be hidden. i only need to search in column 2 but i need to search all rows. i was thinking of something along the lines of [hide all rows] if textbox = [any value in column 2] then [show rows with the value matching the textbox] if any one has any ideas or would like to help me with mine i would be very greatful

I would use a macro with an InputBox to accept the user's text. I would then modify the VBA Help example for Find. The example is already set to loop through a range and repeat the same action each time it finds what it is looking for. However, instead of having it change the value in the cell, change it to set each found cell to EntireRow.Hidden = False

What was I thinking? The VBA Find method doesn't work on Hidden rows. Try a simple For-Next loop instead. Sub ShowInputWord() Application.ScreenUpdating = False Rows("1:1430").EntireRow.Hidden = False MyWord = Application.InputBox("Gimme Something To Work With") For x = 1 To 1430 If Cells(x, 2) <> MyWord Then Cells(x, 2).EntireRow.Hidden = True Next Application.ScreenUpdating = True End Sub

thank you so much... im dont really know much about loops in excel but with your example im sure i could learn alot. thank you both for all your help