Code to hide columns based on value of another column

For columns K and N, if any cell in the range given is blank or No, then the whole columns are hidden? I'm confused by your request. Can you clarify with specifics and examples. Same for Column V.

Yes, if a value that = "Yes" is placed in K then L & M are visible. If no value or the value "No" is placed there, the columns are hidden. So any value that would be placed in cells K2:k466 that = "Yes" make L & M visible. Same for the others.

Column V2:V466 are cells that zip codes go in. When a zip code goes in any of those cells, I want their associated columns to display. Otherwise, they are hidden. This is to keep clutter down because I am collecting large amounts of information.

I'm not sure how to clarify more than that.

Try this code:

Please Login or Register  to view this content.

Shouldn't that go into private sub worksheet under Worksheet Change Event? Either way (general or Worksheet Change Event) it causing an error.

I didn't create it as a worksheet change event. I created it as a straight module based upon your criteria as explained in post 1.

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)

To run the Excel VBA code:

1. Press Alt-F8 to open the macro list
2. Select a macro in the list
3. Click the Run button

If you are looking for a worksheet change event, I will look at changing it up tomorrow, as it is bed time now on the East Coast and I am tired.

Yes, this would need to be automatic. I put a value in a cell, a column suddenly appears. Is this close?

Please Login or Register  to view this content.

Code Tags Added
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 at http://www.excelforum.com/forum-rule...rum-rules.html



(Because you are new to the forum, I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)


Does the code you provided do what you want when you tested it?

What then would you do if there were both yes and no in column K

Please Login or Register  to view this content.