Using an If then statement to hide a column in VBA

Hi,

I am looking to use VBA to hide a column based on the value of another column.

For example, if column G = "Yes", then Hide Column U and If Column G = "No" then Hide column W.

I'm sure this is not very complex but I am just getting started using VBA.

Thank you for your help!!

Makes sense...however I am running into another issue which I believe is the cause of it not working with the above statement.

Column G, the driver, consists of either yes or no in cells G2-G578. However, after running a macro prior to the one that I have a question about above, either "yes" or "no" will be displayed, the other cells will be hidden based on a filtering scheme. I guess my question is what would the proper syntax be to base the the hiding of column U or W off of only the values that are being shown?

Thank you anyone who can help!!!

Originally Posted by MrExcel6543

Makes sense...however I am running into another issue which I believe is the cause of it not working with the above statement.

Column G, the driver, consists of either yes or no in cells G2-G578. However, after running a macro prior to the one that I have a question about above, either "yes" or "no" will be displayed, the other cells will be hidden based on a filtering scheme. I guess my question is what would the proper syntax be to base the the hiding of column U or W off of only the values that are being shown?

Thank you anyone who can help!!!

This will Show\Hide the two columns based on the value in the first visible cell in G2:G578

Please Login or Register  to view this content.

Last question...

How would I change it so the logic is based on other columns hidden

So essentially I need if either G or I are visible....hide W
if either H or J are visible....hide U

THANKS!!!