Hi Macropod



I tried the document on a different PC using word 2013 and the same subscription model. On this occasion the macro worked as you have reported so it appears there is something different on my PC or at least my implementation of MS word. I'm just wandering if this might be because the document originated on the pc of a japanese colleague (who was writing in english in Japan).

I also tried renaming normal.dot before loading any word documents but that didn't make things any different. At least I know I can run on an alternative PC. Otherwise this appears to be one of life's great mysteries or a setting/option buried in the bowels on word.

If you have any final suggestions I'd be glad to hear otherwise I'm not sure how or if it's worth progressing from here.

Hi Macropod

I tried an alternative PC with the same installation method for Office. I transferred a document via a USB drive. The search and replace worked as you have found and not in the way that I'm experiencing. Consequently it seems there is something different about my word/office set up.

Where to next. Repair again. Uninstall/reinstall or something different.

Since the problem is specific to your PC, there's evidently a flaw somewhere in the OS and/or Office installation and/or some other software that's behind it. These kinds of flaw can be very difficult to isolate and sometimes the simplest solution is to reinstall everything, including the OS, from scratch. Before going down that path, though, you might try disabling any 3rd-party addins you have running in Word to see whether that makes a difference.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

I reluctantly did a reinstall. Mainly because a windows update kept failing. I can confirm that in the updated environment I can search and replace for Chrw(12288) without problems.

Many thanks for all your assistance.

One final observation.

The function Chrw(x) only ever seems to returns a positive value.
The function charnum will produce negative numbers.

The value produced by charnum worked best when supplied to chrw. The values obtained by chrw provided intermittent success in the search and replace operation.