Posted to microsoft.public.excel.programming

external usenet poster

Posts: 2

Sum Function in Macro

I need to sum variable length rows in a macro. I use; Cells(ActiveCell.Row
+ 1, ActiveCell.Column).Select and then; ActiveCell.FormulaR1C1 =
"=SUM(R[-54]C:R[-1]C)".

Thanks,
Tim

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
Macro + IF Function?	Gunti	Excel Discussion (Misc queries)	1	December 9th 08 09:08 AM
Using A Function in a Macro	Jai_Friday	Excel Worksheet Functions	2	March 13th 08 01:18 PM
Is there a Function or Macro for This?	Marilyn	Excel Discussion (Misc queries)	6	November 6th 07 03:21 AM
Sub Macro vrs Function Macro Auto Start	Pat	Excel Discussion (Misc queries)	7	June 6th 07 09:53 PM
Macro within a function?	stevieboy1313	Excel Worksheet Functions	1	September 19th 06 07:57 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us