code for how to show only certain columns based on the current visible columns

[kbishop94]

Confusing question, I know. Not sure how to explain it better though (I’m not very good sometimes at trying to effectively communicate what I am wanting… sorry)

So I have a spreadsheet (shown below) that when choosing a certain button (the buttons represent specific departments) the code will highlight only the procedures (rows) specific to that department along with an ‘X’ if that person has been trained for that procedure, and also reducing down the names to only the people that work in that department... (it works pretty slick, if I do say so myself... lol)

Speadsheet as it appears when it is first opened:



Screenshot of the spreadsheet with just the names showing for the "Labels" department (after the labels button is selected)


Ok... now there are hidden column(s) that are to the right of the visible column that shows an "X" (or the cell where an "X" would be) and these are the ones that I need to be visible upon executing the code (ill put in another button for this.)

So when hitting this new button it will look like this:



So what I need is code that when exectuted it will show only columns that are to the right of the visible column(s) that have a name in them. In this case those would be column CH, DX, DZ, and so on...


Is something like this possible? Thank you!

 

[rpaulson]

If I understand what you need then try this.


This will undte the Column to the right of and cell that has and X in it that is not Hidden.
adjust Range as needed

For Each cell In Range("D6:ZZ500")
If cell.Value = "X" And Columns(cell.Column).Hidden = False Then Columns(cell.Column + 1).Hidden = False
Next cell

hth,

Ross

 

[kbishop94]

Thank you rpaulson! Works perfect.