By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,234 Members | 1,908 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,234 IT Pros & Developers. It's quick & easy.

Desperate help - Adding a block of data

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a
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.