Highlight cells with same text

[dado6612]

Hi to all

I want code which will, on some command (ex. double click) highlight all cells in range if they have same text as selected cell.
Ok, I assume that's easy, but problem is, I have merged cells and by my small experience with VBA, I know that codes doesn't work properly with merged cells.

Any help?

Thanks

 

[dado6612]

One last problem
As some code earlier, it deletes all fills in all cells, except conditional formatted
Only cells in range b16:dn16 should be unhighlighted, I hope u can handle that too

I think its final problem

 

[dado6612]

Solved, there is brain in mine head

Thanks again

Edit: Or not :/

Ok, problem is not in Clear code, its in highlight code
It clear all fills in whole worksheet, I don't wana that, can u, please, somehow fix that?

 

[ColinKJ]

Good Luck

ColinKJ

 

[dado6612]

Awwww I fixed that
I'm something like Annoying orange

I just removed "Selection.Interior.ColorIndex = xlNone" line from first code

Thanks again, thats it for now