const filterRange = ActiveSheet.UsedRange
filterRange.ShowAllData;
// 获取自动筛选对象
const autoFilter = filterRange.AutoFilter
// 获取地市列的筛选对象
const filter2 = autoFilter.Filters.Item('F')
// 设置筛选类型为值筛选
filter2.Operator = Enum.XlAutoFilterOperator.xlFilterValues
// 设置筛选的值
filter2.Criteria1 = ['广州']
// 应用筛选
autoFilter.ApplyFilter()