The following example sets a variable to the value of the **Criteria1** property of the filter for the first column in the filtered range on the Crew worksheet.
Some results have been hidden because they may be inaccessible to you
Show inaccessible results