Application Advanced Filter

  • Thread starter Thread starter keyt
  • Start date Start date
K

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.
 
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.
 
Back
Top