Thanks guys. I went with the vb code. worked well.

Last question, is it possible to assign shortcut keys into the code so that I can copy paste the cb code across multiple documents, then just quickly hit a shortcut ket instead of going through the macro menu?

Cheers