在excel vba中应用过滤器后计算所选的单元格范围

Thank you for reviewing my situation :) My attempts for just counting the selected rows in a particular column after applying a filter are pretty messed up. After applying filter, I am counting the selected rows for a column & it reports all rows. The filtered rows are 21 but it seems to be including all rows. I just want the selected rows count after filter. Thank you for reviewing my situation :) My atte