VBA code to filter hidden column

[HMDurham]

Hello! I'm not very good with VBA code so I was wondering if someone could assist me? I have a worksheet with States that are repeated for various rows listed in Column A. Columns B through K have further information that corresponds to each row in Column A. I have each State listed only once in a combobox at the top of the spreadsheet. What I would like to do is hide column A and run a code that would filter the hidden column based on the matching combobox selection. For example, if Alabama is selected in the combobox than the report would filter to show only those rows that correspond to Alabama in column A.

State	ID#	Location
Alabama	6566	Wilhelm
Alabama	6576	Huntsville
Maryland	6689	Market St
Maryland	6888	Bypass Lane

<tbody>
</tbody>

Thank you in advance for assisting me!

 

[sericom]

Try this on combobox change event

Private Sub ComboBox1_Change()
    With ActiveSheet
        .AutoFilterMode = False
        .Range("A1:K1").AutoFilter
        .Range("A1:K1").AutoFilter Field:=1, Criteria1:=ComboBox1.Text
    End With
End Sub

 

[HMDurham]

I get a run-time error '424: Object required for line 5.

 

[HMDurham]

bump

 

[HMDurham]

Never mind. I figured out what I was doing wrong. Thank you so much for the code! It is working out beautifully.