Hi Guys,

I Need a macro that filters my table my a certain criteria in column B, Sorts the table by descending magnitude of the field H, and then copies the top10 values of the field H. I have accomplished the first two tasks already. However, I cant select range H10:H19, since as the filters from the first column change, the first ten values could actually be in rows 25,27,34,56....etc How Can I select the range of the ten first VISIBLE rows as they appeaar after the filter? Thanks