Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem in using Advanced Filter
Hi,
I am trying to use Advanced Filter. I have this code Range("A5:J500").AdvancedFilter Action:=xlFilterCopy, CriteriaRange:=Sheets( _ "Sheet3").Range("A6:B8"), CopyToRange:=Range("A136"), Unique:=False Now the problem with the macro is that even when criteria is changing in Range "A6:B8", it is always giving the same result that it gave when it was run for the first time. What is the reason for this error? Please help. TIA Shilps |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Advanced Filter Problem | Excel Discussion (Misc queries) | |||
Excel advanced filter problem | Excel Discussion (Misc queries) | |||
Problem with Advanced Filter Criteria | Excel Discussion (Misc queries) | |||
Advanced Filter problem | Excel Discussion (Misc queries) | |||
Problem using Advanced filter | Excel Discussion (Misc queries) |