One way

Use a dynamic range name
http://www.contextures.com/xlNames01.html#Dynamic



--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"keyt" wrote in message ...
How do I write in the macro to select the whole data list?

The VB will search a specified region ie: A1:J442, but as
the list grows, I need the macro to update.

Is there a goto last row type command? How do I include
it in:

Range("A1:J442").AdvancedFilter Action:=xlFilterCopy,
CriteriaRange:=Range( _"M1:N3"), CopyToRange:=Range
("P1:Y1"), Unique:=False

Thanks.