Hi Guys,

Trying to figure out how to populate adjacent cells from a function. I have been searching threads and general consensus seems to be that this is not possible. However I have seen a number of examples of this happening, but the code is always locked, most famously probably would be the Bloomberg BDS and BDH formula.

Can Anyone advise on how I would go about this? Every method I've tried doesn't work, my only thought is something like an event sub procedure, but I can't find an example of e.g. onfunctionrun event subprocedure, but can't find an example of this event code either.

Much Appreciated!