VBA code for (un)hide columns related to drop down list doesn't work

Hello Everybody,

I'm sure someone asked already but as I can't find the exact code specified to my worksheet I really would appreciate it if someone could help me with this urgent request.

Column I is a dropdown list which contains the answers 'Yes' and 'No'.
If someone chooses 'Yes' I want Colum J to unhide.
The same goes for:
Column X (Yes) = Y unhide
Column AD (Yes) = AE unhide
Column AH (Yes) = AI unhide
Column AJ (Yes) = AK unhide
Column AL (Yes) = AM & AN unhide
Column AO (Yes) = AP unhide

AND, another one. If the person enters to both columns U&V the number 0, the column AF needs to be unhided. Same goes for entering the number 0 to column S, column AG needs to be unhided.


Can you please help? I tried many times but was unsuccessful.
Thank you!

Please Post a sample workbook with your dropdowns

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

EDITED THIS TIME