See the VBA code below, but it is 1 for Today, 2 for Yesterday, 3 for Tomorrow, and so on. Operator is 11, then there are 34 possible codes stored in. Operator property has a series of numeric codes: Criteria2 property, but it only seems to be used if the filter type is OR. If there is not an array, he can simply use. If there is an array, he loops through the items in the array. Roger checks for an array by asking for the Upper Bound of the array with UBound(.Criteria1). Criteria1 is going to be an array of items. If you open an AutoFilter dropdown and choose Andy, Betty, Charlie, then. ![]() Operator to figure out what filter is applied and what was selected for the column. If a filter is set, it looks at the (1).Criteria1. Roger’s code loops through all of the columns in the current sheet’s AutoFilter. ![]() He adapted that code and then I adapted his code using the great list provided at. Roger Govier had some code that he originally wrote for an article on Contextures. I asked my MVP friends if they had any thoughts on how to do this. ![]() There was an idea posted there, but it only has one vote. Karen already knew to look for the Funnel icon in the header row, but with hundreds of columns, this could be time-consuming. She wants a quick way to see which columns have a filter applied and what filter is applied to those columns. Karen from Chicago has a worksheet with 200 columns.
0 Comments
Leave a Reply. |