A B C D E F G H I J K L M N O P Q R S T U V W X Y Z 0-9 !@$* active | api | Application | array | chart | clipboard | color | date and time | debug | Error | file | filter | find | format | log | loop | named range | PPT | Pivot Table | record | udf | workbook | wrapper Continue at Database_code 948 Steps to 6 Figures by Learning Excel-VBA and Other Skills |
| • | Filtering and visible rows | |
| • | GetNextRow - filtering udf | |
| • | Selection.autofilter = turns off filter | |
| • | range(...).Autofilter Field:=1, criteria1:="=" & sValue, Operator:=xlAnd = recorded sets a filter | |
| • | Cells.autofilter field=lCol, Criteria1:="=*IBM*", Operate:=xlOr, Criteria2:="IBOR*" | |
| • | Remove filtered data but keep filters | |
| • | ActiveWorkbook.Worksheets("....").Autofilter.sort.sortfileds.clear ' clears a filters sorting ' recorded | |
| • | ActiveSheet.PivotTables("pt1").PivotFields("coper_id").PivotFilters.Add Type:=xlTopCount, DataFiled:=... ' recorded | |
| • | Public gsFilters() As Filter_fields 'Filter fields is a udt | |
| • | AutoFilterMode | |
| • | Filter Problems copying moving... | |
| • | Filters | |
| • | Date filtering problem due to 12/1/2021 vs. 12/01/2021 vs. 7/2/21 vs. 07/02/2021 vs. 7/02/2021 | |
| • | CountFiles(sDir, sFilter) | |
| • | 11/12/14 Filter |