Search filter and highlight string - non case sensitive

Hi, really hope someone can help me get this one over the line, thanks in advance...

• I have an table named TrackerTable
• Table starts at row 4 currently around 3k rows and counting
• Table uses columns A-AM
• Table has headers
• I am using cell A2 to input the string I wish to search
• Table has numerical and text based data
• I'm using Excel 2016 if that makes a difference to the coding

The code below will find & filter all rows in my table that contain the search string (text or numeric) entered in cell A2 (non case sensitive). It will also highlight all instances of the search string but only where it matches the case. So my question is can anyone please help adjust the code to make the highlighting part non case sensitive?


Also if anyone can suggest ways to make this code more efficient I would appreciate it. I'm a beginner that just searches the net and cobbles together pieces of code I can find not knowing if I'm using best practice.

Please Login or Register  to view this content.

Thanks & Kind Regards
Steve

Hi Steve
Something like this?

Please Login or Register  to view this content.

hth

Ozex

Thankyou, used your suggested update as above

Awesome thanks so much, works just as I wanted. I did use none selection method as you suggested too.

Please Login or Register  to view this content.