Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
=DMIN(database,field,criteria) question about criteria | Excel Discussion (Misc queries) | |||
Using AdvancedFilter on range of data | Excel Discussion (Misc queries) | |||
Run Time error using AdvancedFilter | Excel Discussion (Misc queries) | |||
How to use AdvancedFilter wildcard to match end of string? | Excel Discussion (Misc queries) | |||
AdvancedFilter question | Excel Programming |