Criteria has to be in a range.

--
Regards,
Tom Ogilvy


"Neal Steiner" wrote in message
...
Dear most valued experts,

I am working on an advancedfilter and the criteria is
the percentages in column B are greater than 0. Can I
have that written in to the criteria code (and if so, how)
or do I need to have the criteria refer to a range?
Attached is the current code, but it is getting hung up on
the criteria range? Thanks in advance

Neal

Sub Macro1()
'
' Macro1 Macro
' Macro recorded 9/10/2003 by Neal Steiner
'

'
Range("A13:B17").AdvancedFilter
Action:=xlFilterInPlace _
, CriteriaRange:="0", Unique:=False
End Sub