Upon investigation, the simplest solution seems to be to:-Make sure you have a
formula that recalculates when filters change. (I used =Count(A:A) in one of
the header cells) - Create a Worksheet_Calculate event macro.
In that macro, you can check to see if the worksheet is filtered: If
(Acti
I have created a macro that will filter information from a report I
generated. I would like to print on the total line the filter selected,
such as
TOTAL FOR EXPENSE GROUP AB
when I select AB from the filter drop down.
How could I do this
Thanks in advance,
Rich
--
Are you =EXP(E:RT) or =N
