Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Please Help AutoFilter
Hello, Friends
1. Application.Dialogs(......................).Show I need Custom Filter Dialog, but in VBA it have not, if found only this(xlDialogFilterAdvanced, xlDialogFilter) Is someone know how can i do this? 2. ActiveSheet.Range(ActiveSheet.UsedRange.Address).A utoFilter Field:=ActiveCell.Column, Criteria1:="=5" I need to know how to get not absolute position of Field:=(ActiveCell.Column) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Please Help AutoFilter
On Jun 3, 12:42*pm, anvarfromkz wrote:
Hello, Friends *1. *Application.Dialogs(......................).Show *I need Custom Filter Dialog, but in VBA it have not, if found only *this(xlDialogFilterAdvanced, xlDialogFilter) Is someone know how can i do this? *2. *ActiveSheet.Range(ActiveSheet.UsedRange.Address). AutoFilter *Field:=ActiveCell.Column, Criteria1:="=5" *I need to know how to get not absolute position of Field:=(ActiveCell.Column) For your 2nd Query: The field argument takes absolute column no Use following: With ActiveSheet.UsedRange .AutoFilter Field:=ActiveCell.Column+1 - .Column, Criteria1:="=5" 'Don.t Miss the . after +1 End With For 1st :No such dialog available for only custom filter |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Please Help AutoFilter
On Jun 3, 3:42*am, anvarfromkz wrote:
Hello, Friends *1. *Application.Dialogs(......................).Show *I need Custom Filter Dialog, but in VBA it have not, if found only *this(xlDialogFilterAdvanced, xlDialogFilter) Is someone know how can i do this? *2. *ActiveSheet.Range(ActiveSheet.UsedRange.Address). AutoFilter *Field:=ActiveCell.Column, Criteria1:="=5" *I need to know how to get not absolute position of Field:=(ActiveCell.Column) Oz has an example of using variables for the filter criteria which might help. http://www.ozgrid.com/forum/showthread.php?t=50818 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel 2007 autofilter change to 2003 autofilter functionality? | Excel Discussion (Misc queries) | |||
2007 excel autofilter back to 2003 autofilter? | Excel Discussion (Misc queries) | |||
2007 excel autofilter change back to 2003 autofilter? | Excel Discussion (Misc queries) | |||
2007 Autofilter worse than 2003 Autofilter | Excel Discussion (Misc queries) | |||
How to Sort within AutoFilter with Protection on (and AutoFilter . | Excel Discussion (Misc queries) |