Hi All
I use the below macro which works extremely well (where the variable cFnd is set to a cell with my search criteria)... is there any way to modify it to also find words where the first letter is capitalised (or ignore letter case altogether)
i.e. now if I search "hello" it will not highlight text with "Hello" - I would like it to highlight both "hello" and "Hello"
At the moment I have to run it twice with the cFnd variable modified... but that makes it very slow !
Any help gratefully received !
Best
James
Bookmarks