Posted to microsoft.public.excel.programming

hal

external usenet poster

Posts: 2

Whats wrong with this VBA statement -ActiveCell.FormulaR1C1...?

ActiveCell.FormulaR1C1 = "=SUM(R[-(Range("j1").Value)]C:R[-1]C)"

I am trying to put a formula in the active cell to sum a list of numbers starting from 1 row up, to the number of rows up that is equal to the value in the cell j1. In other word if the value in the cell j1 was 9, I need to sum from 1 row up to 9 rows up.

Thank you in advance for any help.

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
ActiveCell.FormulaR1C1	Rick	Excel Discussion (Misc queries)	3	March 28th 10 10:36 PM
ActiveCell.FormulaR1C1 = "=SUM(R[-tellerteller]C:R[-1]C)"	Jack Sons	Excel Discussion (Misc queries)	5	September 29th 09 09:58 PM
whats wrong with this?	brownti via OfficeKB.com	Excel Discussion (Misc queries)	10	February 12th 07 02:39 PM
Whats wrong with this?	LucasBuck	Excel Discussion (Misc queries)	3	January 12th 06 08:15 PM
ActiveCell.FormulaR1C1	Leif Rasmussen	Excel Programming	1	October 16th 03 09:46 AM

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

About Us

"It's about Microsoft Excel"

Menu

About Us