Application Advanced Filter

[keyt]

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.

 

[Ron de Bruin]

One way

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

 

[Don Guillett]

Define a name for the range
insert>name>define>type in a name such as myrng>in 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.