Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 08-28-2022, 08:58 AM
Edit4Fun Edit4Fun is offline VBA to replace a repeated single variable with variable from a list Windows 10 VBA to replace a repeated single variable with variable from a list Office 2016
Novice
VBA to replace a repeated single variable with variable from a list
 
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
 

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
I want to create a bar chart of multiple variable. Then I need to draw trend lin of those variable shimulsiddiquee Excel 1 05-16-2017 07:39 AM
VBA to replace a repeated single variable with variable from a list ord vba replace the variable text with variable images to make offer products with images tanzinim Word VBA 4 12-30-2015 01:40 PM
Run Time Error '91': Object variable or With block variable not set using Catalogue Mailmerge Berryblue Mail Merge 1 11-13-2014 05:36 PM
VBA to replace a repeated single variable with variable from a list Run-time error 91 object variable or with block variable not set JUST ME Word VBA 4 03-25-2014 06:56 AM
VBA to replace a repeated single variable with variable from a list Run-time error '91': Object variable or With block variable not set tinfanide Excel Programming 2 06-10-2012 10:17 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:55 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft