Is the following possible in a VBA macro or is it going to be simply too complex? And if so, is there a kind of shortcut so I can change the 'term' (I have 1,000s) each time in an instant? Basically, I'm looking for a custom, advanced 'Find and Replace'.

I'm not asking anyone to write me the code for free, though I know many contributors on here are generous with their time. I simply want to know if it can be done - I know people in far off places who say they can do it, but I don't want to part with my money only to find they can't.

Many thanks, all
Bertie


Find and replace with highlight:

[not preceded by any capital letter or initial upper-case word, except those in a given list, eg 'The', 'Each' etc] [Term in plural or singular form] [not followed by a capital letter]

so I can highlight, eg:

Note, Notes, [The] Notes, [Each] Note, etc

but ignore, eg:

Class A Notes, Noteholder, Note Event of Default, etc