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
Bookmarks