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]
|