I wish to something I think is simple. In a loop, write formulas in a
series of horizontal cells, referencing a series of vertical cells
My attempt:

For ii = 1 To 11
ActiveCell.Offset(12, ii).FormulaR1C1 = "=R[" & ii & "]C[-1]"
Next

Which of course fails, but hopefully gives you the idea of what I
want.

I want the contents of those horizontal cells to end up like:
=H21 =H22 =H23 =H24

Thanks!
allan


--
Spector
------------------------------------------------------------------------
Spector's Profile: http://www.excelforum.com/member.php...o&userid=15618
View this thread: http://www.excelforum.com/showthread...hreadid=271630