How to Hide/unhide columns based on a specific cell's value

[masud_jahan]

Hi all !

I'm looking for codes which will hide/unhide a range of columns based on a specific cell's value. For example,

if cell B9=1, then columns N, O & P should be hidden,
if B9=2, then columns N should be visible but O & P should be hidden,
if B9=3 then columns N & O should be visible but P should be hidden,
if B9=4 then columns N, O & P should be visible.

Thanks in advance

[rcm]

The macro will execute according to the number inserted in B9 as requested

To view the macro, click on the deleloper option and then on the view source

[Trebor76]

This thread has been duplicated here

[masud_jahan]

This thread has been duplicated here

Hi Trebor ! the queries in these two threads are different and not duplication at all.

[masud_jahan]

The macro will execute according to the number inserted in B9 as requested

To view the macro, click on the deleloper option and then on the view source

Thanks RCM !
Iit works fine for B9=1 & B9=4 but if B9=2 then Columns O & P remain visible with N hidden and if B9=3 then only Column P remains visible with N & O hidden.