Just delete them all and reselect the correct ranges using the range select
buttons in the dialog box.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"Jason" wrote in message
...
I'm trying to eliminate duplicates from an imported list and the advanced
step has me stuck. When I get to the advanced filter, there are some word
figures in the "list range". something like "$A$$660:$0$$" I click "ok"
and
it comes up with an error. What am I doing wrong?

thanks
Jason