AdvancedFilter Criteria question

[Neal Steiner]

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

 

[Tom Ogilvy]

Criteria has to be in a range.

 

[Neal]

Tom,

Thanks for the explanation.

Neal

-----Original Message-----
Criteria has to be in a range.

--
Regards,
Tom Ogilvy





.