Macro to hide columns containing blanks

[dvdlev]

Hi,

I am trying to write a VBA code that would allow me to hide all columns containing whatever text/option has been selected from a drop down list in excel.

For example, all the drop down list options are within columns D:Z. The drop down list contains "Cat", "Dog", "Horse", "Fish", " ". If I am selected on the blank " " option in the drop down list then I want to hide all columns in "D:Z" containing blanks.

I am fairly new to writing VBA code and any help would be MUCH appreciated.

Thank you !

 

[alansidman]

If I am selected on the blank " " option in the drop down list then I want to hide all columns in "D:Z" containing blanks.

Do all rows in the column need to be blank or just one row? Your explanation is not quite clear. It may be clear to you, but you will have to explain the nuances of your issue.

 

[dvdlev]

Thats a good question. Yes, I would say all rows in the column do need to be blank in order for it to hide but that should only include the range from D:Z. Let me know if anything else is unclear

Thank you SO much for helping!