Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
getting the filter items
Hi all
I'm uploading excel to access and i would like to get the filter items of one of the columns,is it possible? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
getting the filter items
Try this, but change "A1" to the address of the header cell in your column of
interest: Range(Range("A1").offset(1,0), Range("A1").End(xlDown)).SpecialCells(xlCellTypeVi sible).Select -- Jay "thread" wrote: Hi all I'm uploading excel to access and i would like to get the filter items of one of the columns,is it possible? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
getting the filter items
Hi Jay
I see that its just choosing the column but how can i get all the items for the header? Jay כתב: Try this, but change "A1" to the address of the header cell in your column of interest: Range(Range("A1").offset(1,0), Range("A1").End(xlDown)).SpecialCells(xlCellTypeVi sible).Select -- Jay "thread" wrote: Hi all I'm uploading excel to access and i would like to get the filter items of one of the columns,is it possible? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
getting the filter items
to be more precise,i need the excel column Criteria1
is it posible to loop this data with a macro? thread כתב: Hi Jay I see that its just choosing the column but how can i get all the items for the header? Jay כתב: Try this, but change "A1" to the address of the header cell in your column of interest: Range(Range("A1").offset(1,0), Range("A1").End(xlDown)).SpecialCells(xlCellTypeVi sible).Select -- Jay "thread" wrote: Hi all I'm uploading excel to access and i would like to get the filter items of one of the columns,is it possible? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
getting the filter items
Hi Thread -
I just need to clarify so I can focus on the answer. I'll be unavailable after posting this message, but will check back in about 3-4 hours. Is this correct? You have an autofilter and one (or more) of the fields is set to a specific criterion (resulting in hidden rows in your list). Is this correct? You want to know what criteria are set for each column in the fltered list. -- Jay "thread" wrote: to be more precise,i need the excel column Criteria1 is it posible to loop this data with a macro? thread כתב: Hi Jay I see that its just choosing the column but how can i get all the items for the header? Jay כתב: Try this, but change "A1" to the address of the header cell in your column of interest: Range(Range("A1").offset(1,0), Range("A1").End(xlDown)).SpecialCells(xlCellTypeVi sible).Select -- Jay "thread" wrote: Hi all I'm uploading excel to access and i would like to get the filter items of one of the columns,is it possible? |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
getting the filter items
Hi Jay,
in a way yes,i want to use the filter criteria as a criteria to access, the other option that i have is to loop all the data in the column of the excel file in order to spot all criteria this is the solution i found so far, if you have better solution for me it might faster the loop Jay כתב: Hi Thread - I just need to clarify so I can focus on the answer. I'll be unavailable after posting this message, but will check back in about 3-4 hours. Is this correct? You have an autofilter and one (or more) of the fields is set to a specific criterion (resulting in hidden rows in your list). Is this correct? You want to know what criteria are set for each column in the fltered list. -- Jay "thread" wrote: to be more precise,i need the excel column Criteria1 is it posible to loop this data with a macro? thread כתב: Hi Jay I see that its just choosing the column but how can i get all the items for the header? Jay כתב: Try this, but change "A1" to the address of the header cell in your column of interest: Range(Range("A1").offset(1,0), Range("A1").End(xlDown)).SpecialCells(xlCellTypeVi sible).Select -- Jay "thread" wrote: Hi all I'm uploading excel to access and i would like to get the filter items of one of the columns,is it possible? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filter PivotTable dropdown items to match report filter | Excel Discussion (Misc queries) | |||
Rank items in a filter | Excel Discussion (Misc queries) | |||
filter 10 items from a list of 100 | Excel Discussion (Misc queries) | |||
How do I filter for items that end in % | Excel Discussion (Misc queries) | |||
Extract filter items from Drop-Down Automatic Filter | Excel Programming |