Dear Experts,



I have been trying to write some code to help format a template that creates a report. The Report is created from company software and I always have to make little changes such as Changing the Color of font, deleting/replacing text, and reformatting tables to make it look nicer for clients.

The First issue I have encountered is trying to replace text when there are multiple instances of the same Text, but I only want to change the 2nd or 3rd instance. For example:

Pricing report:

The following Pricing report is blah balh blah blah with the QED figures yada yada yada...

Pricing Graph:
(Graph)

So imagine the above is the Pricing Report, lets say I want to change the Word "pricing" in "Pricing Graph" to yellow, but I do not want any other "pricing" words to change.

I know there is wdReplaceAll- which would change all the "pricing" words to yellow, and there is wdReplaceOne - which would just change the First one in "Pricing Report".

Is there a way to skip the first two and go directly to the Third?

Currently my solution is to turn the all yellow and then turn the other two back to white with the wdReplaceOne feature.

Any help would be appreciated.

Regards,

Whitney