Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
CurrentPageList
I have a Page field and want to apply a filter to the field. For example if
the field has 3 values - A, B, and C. I want to set it to just display B. How can I do this in VBA? I thought CurrentPageList was right but it doesn't seem to work. For this example say the page field is called Letters. Thanks, Joe |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
CurrentPageList
Hello Joe,
We can call Range.AutoFilter function to filter a range of values. Codes look like ActiveSheet.Range("$A$1:$A$24").AutoFilter Field:=1, Criteria1:="B" http://msdn.microsoft.com/en-us/library/bb242013.aspx If you want only show "B", we just need to set the Criteria1 parameter to "B" Best regards, Ji Zhou Microsoft Online Community Support |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CurrentPageList | Excel Programming |