Search Word document based on text in Excel cell.
Just to clarify in case someone else want to use this piece of macro also:
if you use n = 8 then command line
Options.DefaultHighlightColorIndex wil set the highlighted text to WHITE :-(
Small issue but can be annoying if you are searching for a specific piece of text.
Ronald.
|