option open upan editor where
you can apply Criteria to filter
the desired records.
Answers
Answered by
1
Answer:
AutoFilter in Excel VBA can be used with a range object. Like our other functions, this, too, has its own syntax. 1. Range: Range is simply in what range you would like to apply the filter. 2. Field: Field means from which column of the range you have selected you to want to filter out the data. A column will be counted from left to right. For example, if your range is from A1 to D100 and you want to apply a filter for D column, then your field number is 4 because, in the selected range, D is the fourth column. Criteria 1: I…
Explanation:
Similar questions