Hide Columns based on drop down selection

Hi Everyone,

I have attached a sample file where I want to hide the rows based on the drop down selection.

If I select "N" in cell F4 then I want to hide all the columns from BH to FG.
Then If I select "Y" in cell F4 then the VBA should look at cell F6 which has a drop down with numbers ranging from 1 to 104 and based on the selection in cell F6 I should be able to see only the number of columns selected.

I have gone this far with the VBA code but it doesn't work when the drop down number changes each time in cell F6. I also think there would be a way to do with a smaller VBA code. I have attached the file I am working on at the moment.

Please Login or Register  to view this content.

Thanks again. Hoping to get this sorted with someones help.

Cheers,
Piyush

Thank you so much. this works great. I have another question on this thing.

How can I make this work together with another drop down selection that I want to use to hide some columns.

In cell E4 is I select N then I want to hide columns H to BH and then if I select Y in cell E4 then it should look at cell E6 which has again drop down with numbers and I want to hide columns to the left based on my selection. For Example: I select 10 in cell E6 then I should only be able to see columns BG to AX (count to the left) and so on.

Is this achievable.

Thanks again

thank you. This works like charm and exactly like I wanted. Thanks again.