Great! Thanks guys for all the help! Got it working!!!

On Feb 4, 10:51*am, "Niek Otten" wrote:
R1C9

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

wrote in ...

Wow, thanks Niek! Would you know how I could anchor the $i$1 cell in
the R1C1 reference scheme? The row of the active cell that this
formula will go into will be constantly changing.

On Feb 4, 10:38 am, "Niek Otten" wrote:



$I$1 is not a R1C1 reference

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

wrote in ...

| Hi, so I'm having some issues writing a line in a macro that I'm
| working on. I'm not sure why the below formula doesn't work:
|
|
| ActiveCell.FormulaR1C1 = "=bds(RC[-8]&"" equity"",$i
| $1,""cols=7;rows=10"")"
|
| which should get copied into the Excel sheet like this:
|
| =BDS(A2&" equity",$I$1,"cols=7;rows=2")
|
| Can anyone help me out here?- Hide quoted text -

- Show quoted text -