VBA Code to select the first cell after applying Filter

I have a dynamic range A2:M10000
A1:M1 being the headings. WHen i appy the filter using autofilter.criteria I want to select the first cell in column M that appears in the filtered range.

Example if filtered range is
A8:M8
A22:M22
..

in the above case i want to select M8 alone using VBA. When the filtered range changes i want the respective M clumn to be copied and pasted in the next work book.

Thank you so much in advance

Try , below Vrow will give you the first visible Row Number after filter
Sub test ()
Dim Vrow as integer

VRow = ActiveSheet.AutoFilter.Range.Offset(1).SpecialCells(xlCellTypeVisible).Cells(1, 1).Row

end sub