Excel 2007 : Activex textbox search giving error 1004

Hi,

I have a spreadsheet where I would like to search through Column B in order to display the rows which have the information i typed in.

For example, I have a column with , "1357, 1113, 9288, 1209, 2139"
and I type in "13" in the activex textbox, It will only display the rows with
1357
1113
2139

All is working well with this code, but the problem is that it searches through column A instead of B,

Please Login or Register  to view this content.

Now, If it change the Field to 2, would that allow me to search through column B instead?
I get the error:
Run-time error '1004':
AutoFilter method of Range class failed, and the highlighted line is

Please Login or Register  to view this content.

Please help me out if you can! It's my first time using VB =)

That syntax looks correct to me. You may want to put

Please Login or Register  to view this content.

before it to clear existing filters.

My pleasure.

Please do not forget to mark the thread Solved.