Cannot AutoFilter By Exclusion using VBA

Hello:

I have a column that that is populated by #'s. They are there as a result of a VLOOKUP; I now want to filter OUT all the "#N/A" cells for the field.

I cant use a specific array because the data changes every week.

I started writing VBA about 2 months ago, so please be explicit with any suggestions/answer's.

My code is as follows:

Please Login or Register  to view this content.

I have also tried:
Criteria1:<> "#N/A"
Criteria1:=<> "#N/A"



Thank you in advance
Brad

ok thanks, I'm going to try that

What does: "ActiveSheet.AutoFilterMode = False" do?