470,626 Members | 2,153 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,626 developers. It's quick & easy.

Desperate help - Adding a block of data

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
Nov 20 '05 #1
1 960
This is vb.NET newsgroup. You need to repost this on a VBA newsgroup.

Regards - OHM

JM wrote:
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


--
Best Regards - OHM

O_H_M{at}BTInternet{dot}com
Nov 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by KT | last post: by
4 posts views Thread by Bas Groeneveld | last post: by
3 posts views Thread by Renjith Chembakarayil | last post: by
1 post views Thread by Sajid | last post: by
4 posts views Thread by melanieab | last post: by
4 posts views Thread by Giampaolo Rodola' | last post: by
1 post views Thread by cleary1981 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.