Hidding Columns based on Cell Value

Hi Friends,

I have a drop down with value from 1-20. The cell link is B19. Following is the requirement.

When cell value of B19 is 1 columns from R:AN should be hidden.
When cell value of B19 is 2 column R (one column) and AM:AN should be visible
When cell value of B19 is 3 column R:S ( two column)and AM:AN should be visible
When cell value of B19 is 4 columns R:T (three column)and AM:AN should be visible.
.
.
.
When cell value of B19 is 21 columns R:AK (twenty column) and AM:AN should be visible

New to VBA, but trying to modify the following code and is not working. Kindly advice on the correct code.

Please Login or Register  to view this content.

Thanks,
Rahul

Hi Bernie,
Thanks for your quick reply. I did follow the instructions given by you. But the code does is not working at all. When I change the value from drop down (cell link B19), nothing is happening.

Thanks,
Rahul

Thanks so much Bernie. The code is working now