How to add a column without "=SUM(R10C2:R15C2)"

Posted to microsoft.public.excel.programming

Christine[_8_] Christine[_8_] is offline

external usenet poster

Posts: 3

How to add a column without "=SUM(R10C2:R15C2)"

Hi everybody,

I want to add H1:H5, after that H9:H16, etc...

If I use this code it doesn't work for me because my range in H won't be the
same everytime and the total will be always for the same range.
Range("H13").Select
ActiveCell.FormulaR1C1 = "=SUM(R[-5]C:R[-1]C)"
Range("H23").Select
ActiveCell.FormulaR1C1 = "=SUM(R[-8]C:R[-1]C)"
Range("H26").Select

How to write the right code?

Thanks

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Create Pivot Table Data with Column "Sum" rather than "count" defa	Johnny_99[_2_]	Excel Discussion (Misc queries)	2	January 2nd 10 03:25 PM
Chg 1 "Last, First Mid" column to 3 "First", "Middle", "Last" colu	JBird11002	Excel Discussion (Misc queries)	4	August 15th 08 06:31 PM
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell	Steve Kay	Excel Discussion (Misc queries)	2	August 8th 08 01:54 AM
How to entre a "pattern" in a column chart? "used to be in 2003"	Mecckey	Excel Discussion (Misc queries)	1	June 7th 08 02:28 AM
How do I change the column heading in Excel to display "A" "B" "C	Thai	New Users to Excel	1	November 30th 07 08:06 PM

All times are GMT +1. The time now is 02:02 AM.

Menu

About Us