macro to unhide columns based on Month Selection

[Howardc1001]

I have the month and year in Cols C to N

I only want to show the Column with the Month and Year based on the Month Selection in A2

It would be appreciated if someone could provide me with code to do this


I have attached sample data


Your assistance is most appreciated

[Sintek]

Please Login or Register  to view this content.

[Howardc1001]

Thanks for your help Sintek

the code works when I select say June. After I select June and then select say August, I get a run time error

I have copied code into sheet module


Kindly test & amend

[Sintek]

Please Login or Register  to view this content.

[Howardc1001]

Thanks very much Sintek

Code works perfectly