I receive application define object defined error while inserting bloomberg BDP formula to a cell

I get application defined error while inserting a formula that is run by bloomberg addin.

Worksheets("Portfoy").Cells(portfoyCounter, 10).Formula = "=BDP(" & Chr(34) & Worksheets("Portfoy").Cells(portfoyCounter , 3).Value & " ISIN" & Chr(34) & "," & Chr(34) & "YAS_RISK" & Chr(34) & ")*100*"

This code should insert =BDP("XS1634372954 ISIN";"YAS_RISK")*100 this to the cell (portfoyCounter, 10) and XS1634372954 is located in Cells(portfoyCounter , 3)

portfoyCounter variable holds the correct row count I have checked it. I have tried above code in the same manner in different code blocks without any issue but I do not know why I get that error this time.

Tnx vm for you Help in advance.

I checked the counter values but it seems correct.

Upvotes: 0

Views: 93

Answers (0)

Related Questions