Hide columns based on cell value - Unable to set hidden range property of Range Class

test.xlsmHi

I'm trying to write a very simple code (not using case select) to unhide columns based on variable entered into cell C5. (It's a number from 1 - 12 to represent a month)

I tried using offset columns based on the month entered (so... if month is March (3)... ) but I'm getting a error message that I can't figure out....

"Unable to set hidden range property of Range Class"... help?!

Please Login or Register  to view this content.

perhaps change your last line to

Please Login or Register  to view this content.

Easier if you post your workbook with description

Not exactly sure if this is what you are looking for since you didn't provide me with description of the issue, but try

PS: Move your month value in D4 to C3.

Please Login or Register  to view this content.