Filter non-number client names

[Guest]

I need to prepare data to create a PivotTable, and have filtered two columns,

Workbooks("2005q4").Worksheets("Master").Rows("2:" & Rows.Count).AutoFilter
Field:=2, Criteria1:=">=07/01/2006", Operator:=xlAnd,
Criteria2:="<=07/31/2006"

Workbooks("2005q4").Worksheets("Master").Rows("2:" & Rows.Count).AutoFilter
Field:=4, Criteria1:="<>Query", Operator:=xlAnd, Criteria2:="<>Gratuity"

Now i need to filter the client name which are numbers, they look like:

786
AAA
BBB
65
CCC
5677
DDD
EEE
.......

Any suggestions, thank you in advance!

 

[Tom Ogilvy]

Probably easiest to use an adjacent column to put in a formula that will
return a result which is easy to filter on.

=iserror(1*A2)
drag fill down the columrn

Filter on True if you want the non-numbers or False if you want the numbers.