View Single Post
 
Old 08-28-2022, 08:58 AM
Edit4Fun Edit4Fun is offline Windows 10 Office 2016
Novice
 
Join Date: Aug 2022
Posts: 7
Edit4Fun is on a distinguished road
Default 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.
Reply With Quote