Reputation: 1
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