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