How to get rid of unfiltered cells when applying looping functions

  • Hi,

    I have a code which loops through cells after applying autofilter which includes the unfiltered data.

    After entering while loop, the line

    If dico_Triparty.Exists(CStr(wk.Sheets(1).Cells(i, nb_cl))) = True Then

    is searching all unfiltered data and retrieving values to Triparty_pos file

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!