VBA to replace a repeated single variable with variable from a list
Hi. I probably haven't described that very clearly, but what I want to do is this:
I have a list in word that has identical list points with the exception of a single variable (VAR), such as:
This VAR cup goes with this VAR saucer.
This VAR cup goes with this VAR saucer.
This VAR cup goes with this VAR saucer.
and what I want to achieve is
This red cup goes with this red saucer.
This white cup goes with this white saucer.
This blue cup goes with this blue saucer.
So I guess I need a macro that contains a list (array?) of my variables (red, white, blue), and a means of calling the first variable to replace VAR in the first para only; the second to replace VAR in the second para, and so on. (In real life, my list could be a couple of hundred terms long.) If it would be easier if I made a table, and specified changes by row rather than by para, I could do that too. Or even make a 5-col table, with the two VARs in their own columns, which might open up the possibility of having a VAR1 and a VAR2 called from two different lists. (I'm rambling now. Sorry, I'll get me coat.)
Thanks for reading.
|