VBA to replace a repeated single variable with variable from a list

macropod · #1 08-29-2022, 07:11 AM

If you need to replace the same variable twice, simply use:

Code:

    .Execute Replace:=wdReplaceOne

twice...

Edit4Fun · #2 08-29-2022, 01:59 PM

Quote:

Originally Posted by macropod

If you need to replace the same variable twice, simply use:

Code:

    .Execute Replace:=wdReplaceOne

twice...

Thanks again, that's helpful for short lists. The list I did had 24 replacements per set. This will be an ongoing procedure. I guess the solution @maniek proposed is more elegant than making 23 (or however many) copy-and-pastes?

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
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
Run-time error 91 object variable or with block variable not set	JUST ME	Word VBA	4	03-25-2014 06:56 AM
Run-time error '91': Object variable or With block variable not set	tinfanide	Excel Programming	2	06-10-2012 10:17 AM