Dear all

I am having some problem with the use of the Advance Filter , copy to other location.

I have no idea why, i use all name range to input the dialogue box to ensure the inputs are correct.

But it always prompt to me "unable to filter".

I then clear the area and redo again. It then filter out.

May i know what is wrong ?

Eric