Solved: Hiding & Unhiding Columns base on a Data Validation or Cell value

[jammer6_9]

Hi to everyone!

In cell B2 & B3 I have a Data Validation which give months (MMM)
In cel D4:O4 i have (JAN,FEB,MAR, --- to DEC)Now what i want is when I click Data validation in b2 (JAN) and Data Validation in b3 (JUN), JUL to DEC must be hidden. Or in short Column Visibility will be based on Data Validation value. :help I can I hide and unhide column if I will go with one Data Validation only but if I will take the range of two Data Validation, that is where I can not...

[jammer6_9]

Almost got the solution... Just having problem with this

Column = ("D3:O3")
If column.value <> 1 then
column.hide

else
column.unhide

end if