Thread: [Solved] VBA to replace a repeated single variable with variable from a list
View Single Post
 
Old 08-29-2022, 01:59 PM
Edit4Fun Edit4Fun is offline Windows 10 Office 2016
Novice
  
Join Date: Aug 2022
Posts: 7
Edit4Fun is on a distinguished road
Default
Quote:
Originally Posted by macropod View Post
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?
Reply With Quote