This is the newbie again.
What I want to do now is hide columns if a condition is met. The condition is in a drop-down box (named "CrossName") where the user selects if they want to use either an "Exact Match" cross reference or a "Convert Where Possible" cross reference table. What I want to do is this: if the user selects "Convert Where Possible", it HIDES a column that has a percentage drop-down (called "Percentage"), AND the group of columns that have the details of percentage breakdowns. If the user selects "Exact Match", both groups of columns should be visible.
I found some code in a tech manual that hides everything except a certain selection, but that's not what I'm looking for.
Can anyone help me here?
Thanks in advance!!
PS...Here's a little more that I have done...
in the top of the columns I want to hide, there is an "If" statement that says "If drop-down ="Exact", then =1, else =0". then my VBA runs as follows:
For Each c In Range("AT1:BQ1")
If c = 0 Then Columns(c.Column).Hidden = True
If c = 1 Then Columns(c.Column).Hidden = False
This mostly works. I just need it to run every time the drop-down is clicked.