|
Posted to microsoft.public.excel.programming
|
|
|
How copy Criteriarange from uatofilter colun to another sheet?
Example file: http://aljany.com/My_Book_sample2.xls
Question: http://aljany.com/Criterias_list.jpg
"Valery" wrote:
Hello!
I trying to copy CriteriaRange to another sheet but i see error in me code :(
My code is
AutoFilter(2).AdvancedFilter Action:=xlFilterInPlace, CriteriaRange:= _
Worksheet(2).Range("E:E"), Unique:=true
How to copy Criteriarange to another list but so that not turn off
autofilter in main sheet.
|