Desperate help - Adding a block of data

  • Thread starter Thread starter JM
  • Start date Start date
J

JM

Hi all,

Further to my mail yesterday, haven't received much help
and am getting slightly worried !

I am trying to add a block of cells but sadly can't get
excel VBA to exactly read my intentions.

I really wish cells H8 to H12 to be totalised but using
the following statement the formula returns "Sum(H1:H12)


row_no = ActiveCell.Row
ActiveCell.Offset(1#).FormulaR1C1 = "=Sum(R[-" + Trim(Str
(row_no)) + "]c:r[-1]c)"

Can anyone help? I am getting desperate ?
Thanks in advance,
Thanks in advance
 
This is vb.NET newsgroup. You need to repost this on a VBA newsgroup.

Regards - OHM
Hi all,

Further to my mail yesterday, haven't received much help
and am getting slightly worried !

I am trying to add a block of cells but sadly can't get
excel VBA to exactly read my intentions.

I really wish cells H8 to H12 to be totalised but using
the following statement the formula returns "Sum(H1:H12)


row_no = ActiveCell.Row
ActiveCell.Offset(1#).FormulaR1C1 = "=Sum(R[-" + Trim(Str
(row_no)) + "]c:r[-1]c)"

Can anyone help? I am getting desperate ?
Thanks in advance,
Thanks in advance
Click to expand...
 
Back
Top