How to hide and unhide columns based off of a numeric cell value using VBA

[tommyboy1019]

Hey guys,

This is my first time posting, but I've definitely used the forums for help before.
I need to expand and collapse columns based off of the numerical value in cell A1. And I need to use VBA to do so.
Columns B:Z will expand and collapse. For ex. A1 = 0 then no columns show. A1=10 then B:K will show. If I go back to A1=0 then no columns will show again. If A1=25 then B:Z will show.

Please help, I have very armature knowledge in VBA. Any assistance will be appreciated.

Thanks!

 

[dmt32]

I owe you an apology Dave, your code works. You seem to have all the answers. I had my macros disabled like a fool. Thanks for all your help with this. you rock. Quick question though. since I want to hide and unhide based off of cell value, do I need to create 25 cases for each column?

That's very kind of you to say so but I only make suggestions to particular problems that are posted - All the answers are provided by the many who freely contribute to the forum.

Dave

 

[tommyboy1019]

Couldn't figure out how to delete this post so I put this here instead. Please disregard