Hi Paul,

that's very generous of you thank you very much.

I have tested it and it works a charm.

Regarding the earlier issue of previous macro not running - I worked out the problem, albeit a minor detail:

You need to put the cursor in the selected table THEN run macro

When I was opening documents and running previous macro it would not respond, and I couldn't work out why word was being so temperamental.

I am very happy with the solutions and I am sure many people will benefit from it as I spent hours researching macros -and could not find one that allowed me to select more than 1 column or get one to work when testing and creating my own code.

Again Thank you

J

PS - please can admin mark as SOLVED