| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
AdvancedFilter Criteria question
Tom,
Thanks for the explanation. Neal -----Original Message----- 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 . |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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 | |||
![Neal[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
