vba excel Hide Columns Based on User Selection (worksheet change)

vba excel Hide Columns Based on User Selection (worksheet change)

Handy Excel Resources

As an Amazon Associate, I earn from qualifying purchases. Product prices and availability are subject to change.

[osamaasif]

Thank you so much Sir, I appreciate this.

[cameronlebeau]

I have gotten it to work, but is there a way to then do this for a second set of selections with different columns on the same sheet?

[tylerademy]

Hi Alex, this worked great for a project of mine at work, but I am trying to use this same code on another project where there are 4 columns total below 4 merged cells that I am using as the single header for those columns. How can I get it to find that header record and then hide all 4 of the columns instead of just the first column?

[RajINDER]

Hi Alex, I have a problem.
Basically I have an excel sheet which is updated monthly.
Where I have
Jan 2011 a b c , , , ,
Feb 2011 d e f , , , ,
March 2011 g h i, , , ,
..
Feb 2013
March 2013
April 2013

Dec 2014

Where a, b, c.... present values in each column.

[alanmalin]

Hi Alex, how to i apply this to a named range? you apllied this over 4 columns but i could potentially need to apply it over 50. Cheers.

[andreikhalo]

Hi Alex, thanks for the tut, got that error u spoke about "Compile Error Sub or function not defined " on I took time out to copy your exact codes. Why am i experiencing this and how can this be fixed? Can our selected target be on different rows?

[CrazyAdventure]

Thanks, Alex, just completed your steps and the worked a dream. I do have a question though, I would like to group the dates into a month and only show the month we are in and hide the rest. Is this something that can be easily achieved?

[RajINDER]

I want to create a macro so I can hide all the rows corresponding to future date and unhide the rows upto the latest month. Similar to this but instead of columns
I want to hide rows and unhide all previous rows.

[devxc]

Thanks for the tutorial but I have a problem with this one. I recreate to check if I did something wrong but I get a error with that "month_in_review = Sheet1.Range(the_column & "4")" and I don't know why

[rajukodala]

I need Hide And Unhide Column Base on Mutiple Dropdown

[onlg]

Hi Alex
Thank you for you excellent Vedio and The way your lecture
Mr Alex
can you please make one more Vedio
same function with slicer insted off
button or drop down
Thanks in advance
expecting positive response
any one can help inthis regards

[alezander]

Thank you so much for the video. Where i can find the first video with the GetColumnLetter_ByInteger?

[devxc]

error 1004 Method 'Range' of object '_Worksheet' failed
I change the name of Sheet and get error 424 Object required
In this line the_selection = Arka.Range("B2")
Everything is like in your vid just don't work

[ync]

Wish you were a bit more explanatory. You reference things as though we know what they are and you're quick with it, but if we knew we wouldn't be watching your videos.... right?