![]() |
|
|
|
#1
|
||||
|
||||
|
Your worksheet should have headings in Row 1, like:
Find String|Replace String|WildCards|Format|Find Bold|Find Ital|Find U_Line|Find Size|Replace Bold|Replace Ital|Replace U_Line|Replace Size You could add more columns for Find & Replace font colours, etc., too. Other than the Find & Replace string and the font sizes (& colours if you use them), the WildCards & Format columns should contain TRUE or FALSE and, the font attributes, if Format is TRUE should have TRUE or FALSE for whichever attributes you want to use for the F/R process. For the colours, the simplest approach is to use their integer values in a single column. To use RGB values, you'd need a separate column for each or additional code to parse a 9-digit RGB string from a single column.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
VBA Table – Search All Tables - Find & Replace Text in Table Cell With Specific Background Color
|
jc491 | Word VBA | 8 | 09-30-2015 06:10 AM |
| Macro to keep formatted form fields after mail merge or replace text with formatted form fields | jer85 | Word VBA | 2 | 04-05-2015 10:00 PM |
How can I paste text that's not formatted as a table into a new table?
|
WaltR | Word | 2 | 10-11-2014 03:16 PM |
| Word VBA Find Table Text Shading Colour and replace with another | QA_Compliance_Advisor | Word VBA | 10 | 09-19-2014 08:36 AM |
Word VBA Macro to Find and Replace based on the Alt Text of an Image
|
bennymc | Word VBA | 1 | 01-27-2014 04:23 PM |