Advanced Filter problem

O

okanem

I have a series of formulas bringing dates into cells A1 to A10. Th
formulas are simple = another cell formulas.

I am trying to Advanced filter the dates - copy them to anothe
location and also display unique records only. This should display
list of all the dates in Cells A1 to A10, removing duplicates of an
dates listed.

When I click OK after setting up the Advanced Filter as above I get th
error - The extract range has a missing or illegal field name.

Can anyone help.

I know that if I simply type the dates and run the filter it work
fine, but this is no good for me.

Rgds
Okane
 
D

Dave Peterson

Get a copy of Jan Karel Pieterse's (with Charles Williams and Matthew Henson)
Name Manager

You can find it at:
NameManager.Zip from http://www.oaltd.co.uk/mvp

You'll be able to find that offending name and delete it.

(You could write your own macro looking for that offending name, but this addin
is so useful, it gives you a reason to go get it!)
 
D

Debra Dalgleish

Does the heading in the extract area exactly match the heading in the
date column?
 
P

Prashant Garg

I have also faced this problem twice.. and everytime I searched for results
here but no satisfactory answer was here... but to my luck I was able to
correct it...

For the first time the error was in the data table, I selected the data
range as Range("a1"),, row 1 being the headers, not realising that the cell
A2 was empty, when I put some numbers in all the columns of the first row,
the advanced filter worked.

In the second instance , my selection criteria was just above the data range
and I didn't leave a blank row between name range and data range ,, thus
forumla kept showing this error, but once I inserted a blank row formula
worked
I hope this will serve ur purpose
 
Top