frubeng
06-10-2010, 06:12 AM
Hi,
I have a macro that runs the line (among others):
Workbooks("beta.xlsm").Worksheets("beta").Cells(x + counter2, 4) = "=BDP(RC[-3] & "" Equity"",""EQY_BETA_RAW_OVERRIDABLE"",""EQY_BETA_OVERRIDE_REL_INDEX"",Results!F1)"
However, the cell content shows up as:
=BDP(A14 & " Equity","EQY_BETA_RAW_OVERRIDABLE","EQY_BETA_OVERRIDE_REL_INDEX",Results!'F1')
In the excel cell. The problem is that the "F1" is surrounded by apostrophes which is causing my BDP function not to work . Anyone have any ideas?
Thanks!
I have a macro that runs the line (among others):
Workbooks("beta.xlsm").Worksheets("beta").Cells(x + counter2, 4) = "=BDP(RC[-3] & "" Equity"",""EQY_BETA_RAW_OVERRIDABLE"",""EQY_BETA_OVERRIDE_REL_INDEX"",Results!F1)"
However, the cell content shows up as:
=BDP(A14 & " Equity","EQY_BETA_RAW_OVERRIDABLE","EQY_BETA_OVERRIDE_REL_INDEX",Results!'F1')
In the excel cell. The problem is that the "F1" is surrounded by apostrophes which is causing my BDP function not to work . Anyone have any ideas?
Thanks!