Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Advanced Filter to Dynamic Range
I've applied an Advanced Filter to a Range and simply recorded the macro,
extract below, but my problem is that my data in the Database sheet is dynamic and changes in Row length (not by column) How can I incorporate a dynamic range via VBA with Advanced Filters? Thanks Sheets("Database").Select Range("A1:T61").AdvancedFilter Action:=xlFilterCopy, CriteriaRange:=Range( _ "V1:V2"), CopyToRange:=Range("X1:AQ1"), Unique:=False Range("A1").Select |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Advanced Filter using a range name as the criteria | Excel Worksheet Functions | |||
Advanced filter a dynamic date range | Excel Worksheet Functions | |||
advanced filter a range | Excel Worksheet Functions | |||
"Criteria Range" in the "Data/Filter/Advanced Filter" to select Du | Excel Worksheet Functions | |||
Advanced Filter & Named Range | Excel Programming |