Hide row if a cell value in the row does not equal one of values in a range

[VBanal]

I am writing my first excel Macro so am keen and excited! However, I am having problems with the code. My objective is to first check whether any of the 6 values in cells H2:H7 are present in any of the cells in column B starting from cell B10. I want to hide the rows where the values are not present. This is the code I have come up with but I keep getting various errors. Any help would be much appreciated!!

Please Login or Register  to view this content.

[alansidman]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(I have added them for you. Please add them in the future.)

[VBanal]

Thanks for babysitting me on this one! Will keep in mind for future posts.

[VBanal]

Hi,
I want to hide rows where a particular cell in that row does NOT contain a particular value. When I run the code below, the following error is shown: Run-time error '424' Object required. How do I correct the code? Thanks very much

Please Login or Register  to view this content.

[alansidman]

Try this instead:

Please Login or Register  to view this content.

[VBanal]

This works, thanks very much!

The above macro hides cells as long as data in column B does not match date in cell H2. I now want to provide the spreadsheet user guidence on what to fill in cell H2. This is very much like what one sees on "web forms" which prompt you to provide First Name, Middle Name, Last Name, Address and so forth. Guidance is provided in the text box itself but disappears when one clicks in to the text box. Can something similar be done on an xl spreadsheet?

[alansidman]

Are you looking for some sort of data validation? Look at this link --

http://office.microsoft.com/en-us/ex...010072600.aspx

[VBanal]

Thanks. Very useful!