Hi Paul,
Thanks for the advise.

On the same subject, I have another complicated IF statement used in hundreds of documents which I have had to change to accommodate Office 2013.

When using If ....<> "" , to make it work in 2013, I had to put a space between the quotes ....<> " "

The 2013 version doesn't work on previous versions, and what I was using in previous versions doesn't work in 2013.

It means maintaining 2 sets of documents for the same application, which is the kiss of death as far as I am concerned.

I don't suppose there is a solution, but thought I would mention it.

Any signs that Microsoft might return to or fix the use of dde?

Brenda