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!