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
 



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 03:20 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