| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filter Macro that can work for any column/active cell
I have recorded a macro but unfortunately it only works for one column. I
would like it to apply to any column and be dependent on what is the active cell. How do i change this code to do that? I'm not sure what the field = 24 stands for and what I can replace it with to make it based on the active cell. Sub Filter0() Selection.AutoFilter Field:=24, Criteria1:="<0", Operator:=xlAnd End Sub |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Filter on active cell | Excel Programming | |||
| Macro to Filter on active cell within autofilter | Excel Programming | |||
| on which column is the filter active? | Excel Programming | |||
| Active Cell to be used as filter... | Excel Programming | |||
| how do find out the column of the active cell in a macro? | Excel Programming | |||
Threaded Mode
