Application Advanced Filter
 

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.

Application Advanced Filter
 

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.

Application Advanced Filter
 

Define a name for the range
insertnamedefinetype in a name such as myrngin the refers to box
=offset($a$1,0,0,counta($a:$a),9)
enter
now test by f5 and typing in myrng to see what is covered.

"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.