Search results for query: *

Skip, regarding your first post, yes exactly. Regarding your second, I do not select any cells, I even tried adding the field in the formula to set the rows = 1 and the columns flexible but when the formula runs it seems to override this. I will search on array fomulas as I am unfamilar with the...

If you have access to a bloomberg terminal try the following in a cell, =bds("AIR EQUITY", "BOND_CHAIN") the output will contain 2 rows of data, 4 columns.

When copying and pasting the second row of output from say cell k, overlaps the first row of output for cell k+1.

Skip, I do agree and would have preferred to use it directly in the worksheet. However, I have around 15000 different equities that I am using, and the formula gives 2 rows and many columns of output so I cant just drag the formula down the spreadsheet. I have not found a way of suppressing the...

Okay will do, and the import is taking place on the line Cells(k + 1, "F").Formula = "=bds(" & Chr(34) & arrNames(k, 1) & Chr(34) & ", " & _ Chr(34) & "BOND_CHAIN" & Chr(34) & ", " & Chr(34) & "dir = h" & Chr(34) & ")" The only issue is that the data is not imported to the current...

After a little bit of debugging I realize that my problem is that the data is "being requested" while the loop moves to the next k. I need the formula to populate the cells before moving to the next k. The output is x columns and 2 rows which is why I would like to remove the second row before...

I have a loop in which I am using a the Bloomberg BDS formula. I need the formula to execute, i.e. actually download the data, before the loop continues. Is there a method for ensuring the data is read-in before looping to the next cell? Thanks in advance.

Hi Skip, What I mean by function is the built in excel function "BDS." It is an Excel function provided by Bloomberg. I am not writing a function just using this built in one. Thanks Mike

Hi, I am using a Bloomberg function that gives its output on 2 lines (rows). The function is looping over a large number of cells so what I would like to happen is for the function to run on cell 'k' then to take paste the first line of output into another worksheet. Before moving to the next...