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.