Hi All,

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!!
Leta

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:

[Sub hidecolsif()
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
Next c
End Sub]

This mostly works. I just need it to run every time the drop-down is clicked.

Never mind, I got it to work. Here's the code for those that want to do the same thing. The drop-down is in Cell AR9.

[Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$AR$9" Then
Call Sheet2.hidecolsif

End If

End Sub

Sub hidecolsif()
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
Next c
End Sub]