Highlight numbers in word doc

**steve61** · 06-17-2013, 09:54 AM

Hi

I am trying to automate the copying of Excel data into some Word docs. The body of the Word docs all start like this (below the title and date) and I need to past in the new performance figures every month:

"The portfolio outperformed its benchmark in January, turning in a net performance of -3.27% (in US dollars), compared with its benchmark’s return of -2.97% (also in US dollars)."

The problem I am having is that I can search for and select the % sign, but cannot expand the selection to all the numbers as the macro does not recognise it as a word and only highlights the % sign. Since the numbers can be negative and so include a minus sign I cannot use a character count as it can vary. Lastly, the spreadsheet I am copying from does not include a % sign so I will need to add that back in if pasted over.

Here is the macro that I have got at the moment

Please Login or Register  to view this content.

Thanks in advance for any help with this

**zbor** · 06-17-2013, 09:55 AM

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code in [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here