Hi Guys,

Im having a problem with the following:

I have Cell "BB1" with the following Bloomberg Hyperlink:

=HYPERLINK("bbg://securities/"&BC1&"& Corp/DES","Bond DES")

This basically opens up a BBG Pop up window with information about a particular security.

I have tried to follow the hyperlink through a macro using:

Worksheets("TOTAL").Range("BB1").Hyperlinks(1).Follow

But I get Runtime Error 9 - Out of range. Any ideas as to why this is happening. Maybe I have to instruct it to open it with Bloomberg, anyone know how to do this? Thanks