Macro to hide a row if column D has some text or number which i am searching for

[kishoremcp]

hi,

I have a workbook in which I have 9 columns. I want a macro which should give a search box and I will type a search string/number. It should search for that search keyword in column D and then hide that particular row completely.
Also, I need a button (if possible) on the same search box which can unhide all the rows.

Please help.

[:) Sixthsense :)]

How to install your new code

1. Copy the Excel VBA code
2. Select the workbook in which you want to store the Excel VBA code
3. Press Alt+F11 to open the Visual Basic Editor
4. Choose Insert > Module
5. Edit > Paste the macro into the module that appeared
6. Close the VBEditor
7. Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)

Please Login or Register  to view this content.

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.