Hi

Thanks for the reply.

I want to set a filtered criteria to some other cell.

e.g. I have a filter set on Country column, now when I select UK,
obviously my filter will display records against UK but, on selection
of UK i want to call a macro which will set a filter criteria value
(i.e. UK) to a cell lets say A1.

Note: I have already wrote a function to retreive filter criteria and
want to call in on change of filter criteria, so basically looking for
a trigger to call this function.

Thanks!
Milind