S
Steve
I'm trying to show the filter criteria when printing. I've seen VBA code by
several MVP's, and all work great as far as showing the criteria in a cell
in the worksheet. I've written code in the ThisWorkbook object using the
BeforePrint event to put the values in a header, but I'm limited to only 2
criteria. However, I want to show all of the filter criteria, not just 2
per column. In Excel 2007, when auto filter is on, and the mouse hovers
over the filter arrow, it shows all of the filter criteria, not just 2.
For example, the worksheet has several thousand rows, and Column A has 20
unique values. I want to see only the rows with Column A values of 11, 30
and 66. I can manually select all three values from the auto filter list.
When the mouse hovers over the auto filter arrow in column A, the values 11,
30, 66 are displayed in the bubble. How can I get those values to print?
Is there a builtin way to show this in a header or footer in Excel 2007? If
not, can someone offer some VBA code to show more than 2 criteria?
Thanks,
Steve
several MVP's, and all work great as far as showing the criteria in a cell
in the worksheet. I've written code in the ThisWorkbook object using the
BeforePrint event to put the values in a header, but I'm limited to only 2
criteria. However, I want to show all of the filter criteria, not just 2
per column. In Excel 2007, when auto filter is on, and the mouse hovers
over the filter arrow, it shows all of the filter criteria, not just 2.
For example, the worksheet has several thousand rows, and Column A has 20
unique values. I want to see only the rows with Column A values of 11, 30
and 66. I can manually select all three values from the auto filter list.
When the mouse hovers over the auto filter arrow in column A, the values 11,
30, 66 are displayed in the bubble. How can I get those values to print?
Is there a builtin way to show this in a header or footer in Excel 2007? If
not, can someone offer some VBA code to show more than 2 criteria?
Thanks,
Steve