I notice that when I use vba code to write a "blp" function into a cell it flickers the cell for a long time for no reason, finally value comes in, but i have no idea why this is happening, any pointers helpful should i even be doing it thing way. thanks