searching through columns

[ikkyu2]

Hi everyone, I found some code on the internet that has one combox one textbox and one listbox. I've tried to modify it to work on a sheet that has 3 columns from which I am trying to search. The data in the columns are in the range H2:J10000. When I run it I get an error message that says "The extract Range has a missing or illegal field name."

The line that is highlighted in yellow on the vba code is "DataSH.Range("h2").CurrentRegion.AdvancedFilter Action:=xlFilterCopy......."

Does anyone know what I am doing wrong.

[mikerickson]

Have you tried it with an explicit range, like this?

Please Login or Register  to view this content.

[ikkyu2]

mikerickson, Thank you for your reply. I tried your suggestion and it still was not working. I just moved the data to be searched to columns a:b and it works fine.