Thanks guys,

This type of functionality is included in the Bloomberg addin, I think
it must have been coded in C+. I'm not quite at that stage but had
already started to look into xll addins.

Regards,

Toy.