Your code works perfectly for me, assuming that the various ranges are
set correctly (e.g., that target is indeed in column 2, and that the
text value in F12 exists within fltrCriteria.

When you step through your sub, is the code that you gave executed?

Do you have any other event code running?

In article ,
Ken McLennan wrote:

G'day there One & All,

Back once againg with something not working as I thought.