N
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
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