Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro : seeking max value after an Autofilter
Dear Experts
My excel sheet encloses 2 columns - 1st column is a zip code with Data/Filter/Autofilter on - 2nd column is a numbe In a macro : - I filter data of the1st colum using the autofilter (i.e. Selection.AutoFilter Field:=1, Criteria1:="10080" - I want then to get the max of the resulting numbers in the 2nd one but how can I specify I want the max of the subset of data and not the max of the full data enclosed in the column (i.e. when no filter is not set on 1st column) Any help greatly appreciated Regards Jerome. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro, AutoFilter... | Excel Discussion (Misc queries) | |||
Autofilter Macro? | Excel Discussion (Misc queries) | |||
AutoFilter Macro | Excel Worksheet Functions | |||
Macro using autofilter | Excel Discussion (Misc queries) | |||
Keep autofilter after macro is run | Excel Worksheet Functions |