Hide ranges that don't match criteria

  • Your help please, I have the code below from a post which loops through all ranges starting with ‘MyRng’ (there are 70 of these) then do something which works perfectly, the problem is I need it to then check the combobox1 selection (or the linked cell) and find any matches in column A from row 5 down of all the ranges ‘MyRng’ and then hide any ranges/rows that don’t contain a match these can be text or numbers.

    All the ranges ‘MyRng’ are in column A and will be blocks of 6 or 7 rows can you help or am I on the wrong track completely?

Participate now!

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